How do I get tab control first tab on entering a new Record?

[slagg7575]

Hi all,

I have a subform with about 8 tabs, and I would like for when a user
hits the new record command button >* for the new record to be
defaulted at the first tab in the order of 8. The tab name is Visits,
and I need the user to enter data in here first before anything else on
the new subform record. So if the user was on tab 8 (Meds), and hit the
new record button, the new record would be displayed and the first tab
in the tab control would be set to Visits.
I have no problem with the command button for new record, that works
fine, I just need a default tab set to visits.

Thanks for all your help and time!

 

[Guest]

Hi,
you could use the on click event of your new record button or the on current
event of the subform e.g.:

If Me.NewRecord = True Then
Me.Visits.SetFocus
End If

HTH
Good luck

 

[slagg7575]

Hi freakazeud,

Worked like a charm....thanks a zillion!