G
Guest
Hopefully someone out there can help,
There is probably a simple way of doing this but I am at a loss (I wouldn't
consider myself an expert in access)
Anyway, here is what I'm trying to do.
I am currently using a form to update a table, One of the fields is for a
job number. An additional text box on the same form is for the job name.
What I am trying to do is have the job name automatically fill out by using
data from a different table that already contains the job name information.
I have the two tables already relationshipped according to the job number,
but how do I tell Access to update the 2nd text box with the name information
based on what the user has entered as a job number in the first box?
I suspect that I need to run a query in the background but I'm not sure how
to do this.
(Would I use the expression builder?)
Hopefully what I wrote makes sense. If you need more info. please let me
know. I'm getting tired of knocking my head against my cubicle.
Thanks
Jim
There is probably a simple way of doing this but I am at a loss (I wouldn't
consider myself an expert in access)
Anyway, here is what I'm trying to do.
I am currently using a form to update a table, One of the fields is for a
job number. An additional text box on the same form is for the job name.
What I am trying to do is have the job name automatically fill out by using
data from a different table that already contains the job name information.
I have the two tables already relationshipped according to the job number,
but how do I tell Access to update the 2nd text box with the name information
based on what the user has entered as a job number in the first box?
I suspect that I need to run a query in the background but I'm not sure how
to do this.
(Would I use the expression builder?)
Hopefully what I wrote makes sense. If you need more info. please let me
know. I'm getting tired of knocking my head against my cubicle.
Thanks
Jim