How do I change tab order on tab control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a new Access user so please bear with me...

I have a form that has numerous fields, and I have broken them down into
logical groups using a Tab Control. I currently have 4 tabs on the control.

My problem is that I want to go from the last field on one tab to the first
field on the next tab without having the record saved until tabbing through
the last field on the last tab. I tried changing the Context setting of the
form, and the tab order - the tab order only shows the order of the fields on
the active tab.

Anyone have any ideas?

Thanks in advance for any help you can provide.
Bill
 
You'll need to use VBA code to move the focus to the desired control on the
next tab page. You could use the Exit event of the last control on the one
tab page to set the focus to the first control on the next tab page.
 
Back
Top