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

  • Thread starter Thread starter slagg7575
  • Start date Start date
S

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!
 
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
 

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

Back
Top