Tab Controls/Subforms

[amanda_jb]

I'm hoping anyone can help me... I am currently re-designing our company
database and per their preference they want the database to have the tabbed
controls to navigate. The problem I am having, due to trying to minimize
size, I need the Subforms contained on these tabs to be deactivated until the
Tab/Page is selected; however, it does not recognize for some reason the
onclick when you selec the tab, it has to actually be clicked on the page.

If anyone has any pointers... I would greatly appreciate it!!!!!

 

[Jeff Boyce]

Amanda

One way to do that is to use an OnChange event procedure for the control
(the tab control, the whole thing, not a page on it). You could use
something like:

Select Case Me!tabYourTabControl.Value 'which tab was clicked
Case 0 'the first tab was clicked
'do something
Case 1 'the second tab ...
'do something else
...
End Select

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Graham Mandeno]

Hi Amanda

Use the Change event (not the Click event) of the tab control.