Refresh - Requerry - Update?

[Michelle]

I have a from that uses two tables what I need is once you enter the employee
# in to the first column it should update the next 3 fields with the related
info from the main table...example
Table 1 has and Table 2 has
Emp# Emp # (this is the relationship)
N_Title Name
N_Date Title
N_Office Office

What I want is to be able to do is type in the Emp # hit tab and it pull the
Name, Title and Office from the related table I would then be able to enter
the New Title, Office and Date of the change.

 

[Michelle]

OK...Figured this out...however what I did was Requerry which jumps my cursor
up to the first box in the form...is there anyway to make it goto the N_Title
for the record I am on after the requerry?

 

[Toco]

After your rrequery statement, set the focus to whichever control on the form
your wish.....Anycontrol.Setfocus

 

[Michelle]

I used an on Entry Macro to get my results how would I add this to that or
would I need to make it code.

 

[Toco]

If you are using a macro, you will need to add a line after your requery
statement in the Macro window. I think the Action is GoToControl. At the
bottom of the window you can list the Control name. Let me know if this post
helps.

-Toco-

 

[Michelle]

That worked however I now enter the # hit tab it fill it in then I move to
the next line to enter the next # after I hit tab it moves to the first line
again. Any idea on how to fix that.

 

[Toco]

It's probably best to set the tabbing order. Tab order can be set on the
form. If you right click the box that is left of the label that says 'Detai'
(with an arrow pointing down), you will see Tab Order. This may eliminate
the extra macro you wrote--the one about setting the focus