I need to display values from a linked table

[tjcinnamon]

I have attached a database which is an example of our work in progress. What I am trying to accomplish is when I enter a job number in a text box, a corresponding Owner name and tenant name will be displayed in a text boxes. I have an example linked table in the database and will link it to the real table when I get it to work. Any suggestions or edits and repostings would be appreciated.

Thanks, JOe K.

View attachment Work in Progress Jan 2007.zip

 

[stepone]

You just need to put a me.requery in the AfterUpdate event of the File Number control on the JIP Entry form.

StepOne