I am trying to add some functionality to a form.

I have it set up so that when the user goes to add a new record, the focus 
goes to a control that is in the form header (basically an account number 
that is entered first).

Then in the form detail I have the rest of the controls for the required 
data (first, last names, etc.). Basically I want the acct. number at the 
top of the screen while the user inputs or views data that is past the 
bottom and they are scrolling down. The way it is they have to use the 
mouse to click in the detail first control.

Viewing and setting tab order from the menu bar only allows it to be done 
separately in header, detail and footer; and the tab index property starts 
at zero for each section and so can't manipulate that.

I want the tab control to be able to go from the form header to the first 
tab number in the detail section. I've checked a couple of other simoar 
questions in the archive, but they all pertain to within the form detail 
or subform. Responses suggested using code for the "OnExit" or 
"OnLostFocus" events of the last control in the 1st subform that 
"setfocus" to the first control of the next subform, but I've tried a 
couple of things there but it doesn't work adequately.

Any suggestions?

Regards,
Eric