If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Tab Controls/Subforms
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!!!!! -- Amanda |
#2
|
|||
|
|||
Tab Controls/Subforms
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 "amanda_jb" wrote in message ... 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!!!!! -- Amanda |
#3
|
|||
|
|||
Tab Controls/Subforms
Hi Amanda
Use the Change event (not the Click event) of the tab control. -- Good Luck :-) Graham Mandeno [Access MVP] Auckland, New Zealand "amanda_jb" wrote in message ... 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!!!!! -- Amanda |
Thread Tools | |
Display Modes | |
|
|