Determing Current Page (Tab) on an Access Form

[Randoz]

I have 4 different pages (Tabs) on a form filled with different data. I have a 'Save" button for the whole form. When I click on the save button I want to be able to do different funcitons based on which Tab is on top. What VBA code do I use to determine what Tab is on top.

[rsmccli]

I would use a Select Case statement with the argument as the tab control's current value.

Select Case Me.TabControlNameHere.Value
Case 0 
  Do stuff for first tab.

Case 1 
  Do stuff for second tab.

'However many you need...

End Select

hth,
rsmccli

[Randoz]

Thank you so much, it worked great.