Same subform in multiple tabs of tabbed control ???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a tabbed control, within 3 of the tabs I have a subform containing a nested tabbed control (the only reason I use a subform - it is not linked to the main form in any way). The same subform is in each tab and it is formatted depending on which main tab is clicked. But Access insists on me giving each subform a unique name
Does that mean that I cannot manipulate the contents of this subform using a single name but I have to treat it as three separate subforms? In other words, I have to format three subforms instead of just one?
 
Have you considered an altenative to using the Tabs? I've
never tried this myself, so I'm not sure how it will
work...but....

If you used a general Subform and had buttons instead of
Tabs for each Tab heading, you could reset the record
source for the subform when the button is clicked.

btnCustomer would have for its On Click event

Me.SubForm.SourceObject=frmCustomer

then use

Me.Recalc

to refresh and recalculate the frmMain.

This way you only have one basic Subform on your form that
acts as a skeleton framework into which your other forms
can be loaded into as well. Please let me know if that
works - that is if it is something you try.
-----Original Message-----
I have a tabbed control, within 3 of the tabs I have a
Click to expand...
subform containing a nested tabbed control (the only
reason I use a subform - it is not linked to the main form
in any way). The same subform is in each tab and it is
formatted depending on which main tab is clicked. But
Access insists on me giving each subform a unique name.
Does that mean that I cannot manipulate the contents of
Click to expand...
this subform using a single name but I have to treat it as
three separate subforms? In other words, I have to format
three subforms instead of just one?
 
Back
Top