How do I change tab order on tab control

[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

 

[Ken Snell [MVP]]

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.