Select first tab in tab control on record change

S

Sandy

I have a form with a tab control that has several tabs.

How do I get the first tab to display when I change records? Currently the
last tab that was active stays active when I change records.

Many thanks,
sandra
 
P

Paolo

Hi Sandy,
on the oncurrent event of the form containing the tab control insert this

TabCtl0.Pages.Item(0).SetFocus

and substitute TabCtl0 with the name of your tab control.

HTH Paolo
 
L

Linq Adams via AccessMonster.com

Private Sub Form_Current()
Me.YourTabControlName.Value = 0
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Naming of Form Button 3
Paragraph numbering in Word 1
Tab Control select issue 5
Need Tab Control Advice 2
Adding data to MS Access from csv file 0
Setting the number of Tabs in a Tab Control 0
Drop down list control value in vba 2
VBA word change keys 0

Top