Hi,
My user form is basically just a pair of tab controls. This is fine, but my question that after tabbing past the last field on tab1 the form goes to the next record, rather than to the fields displayed on the 2nd tab. How can I make the tab order go from tab1 to tab2, and so on…?

Is this just a simple case of changing the tab index b/c I haven’t tried that yet. Thanks everybody for all of your help now, and in the past!

Set the properties in the form for Cycle to Current Record, then on the OnExit property,
DoCmd.GoToControl "ControlNameOnTab2".


[This message has been edited by pdx_man (edited 01-26-2001).]