Tab Controls in Access 2000 - TechRepublic
General discussion
April 10, 2001 at 06:19 AM
rdeen

Tab Controls in Access 2000

by rdeen . Updated 25 years, 2 months ago

I have dropped the following code into my tab controls:

If Me.TabCtl1.Value = Me.TabCtl1.Pages(“Page1″).PageIndex Then
DoCmd.OpenForm FormName:=”frmTabs”
End If

If Me.TabCtl1.Value = Me.TabCtl1.Pages(“Page2″).PageIndex Then DoCmd.OpenForm FormName:=”frmOverTime”
End If

If Me.TabCtl1.Value = Me.TabCtl1.Pages(“Page3″).PageIndex Then
DoCmd.OpenForm FormName:=”frmTraining”
End If

If Me.TabCtl1.Value = Me.TabCtl1.Pages(“Page4″).PageIndex Then DoCmd.OpenForm FormName:=”frmTravel”
End If

If Me.TabCtl1.Value = Me.TabCtl1.Pages(“Page5″).PageIndex Then
DoCmd.OpenForm FormName:=”frmContractExpense”
End If

If Me.TabCtl1.Value = Me.TabCtl1.Pages(“Page6″).PageIndex Then
DoCmd.OpenForm FormName:=”frmOtherExpenses”
End If

What happens is that the tab I click on will open, but I must close the form before I can open another form. I would like to just click on any tab and have it open withouth having to close any form. Can somebody help me tweek the code to accomplish this?

This discussion is locked

All Comments