GoTo Control

[Michelle]

I have a DB with a from when you input the emp # it pulls the name, dob, etc
from one table then you are to enter data in the rest of the empy fields on
the form. The form is laid out in Tab view (which doesn't matter much) except
after you enter your data on the first line and hit enter to move down then
enter the emp # and hit tab to populate the other fields it moves you back to
row 1.
My Macro is...
Requery
GoToControl with the control being the field name I want the courser to move
to.
is there any way to keep it in the same line?

 

[bob]

go to properties for the form and adjust the tab order

Bob Galway

 

[Steve Schapel]

Michelle,

This is the result of the Requery action. I am not sure what the
RTequery action is supposed to achieve here - doesn't make sense to have
it there in any case, though I may be wrong without knowing more about
your form. Try removing the Requery action from the macro, and see how
it goes then.