tab control in form

[Guest]

I have a main form that when I type in the emp # it brings back employee
inform from a sequel table, then I have a subform that the user can add data.
Question, when I type in the employee # and then click my mouse in the
subform, the correct employee infor stays, but if I press the Tab key to go
to the subform it picks up the next emp# (example: typed in 03218, tab and
it goes to 03219, etc.). Is there a reason the tab function does not work
correctly? I hate to have to click the mouse in the subform each time.
Thanks,

 

[Van T. Dinh]

It sounds to me that the [emp#] Control is the last Control in the Tab order
of the MainForm and the Cycle Property of the Main Form is set to All
Records.

Check the Tab order of the MainForm and change it so that the Subform
follows the [emp#] Control.