I have two tables. One has Job Number, County, Route. The other has Job Number, Cost. They are linked on the Job Number. On my form, I want to enter a Job number and have the County, Route display automatically from the table. Currently, the County,Rte data isn't displaying until after I close the form and reopen it. How do I make it show up immediately?

[This message has been edited by vickiwells (edited 03-05-2001).]

Requery after specifying the JobNumber.

How do I do that?

In the afterupdate event of [Jobnumber] on the main form, put: Me.Refresh. Should do it