Data in forms

N

Nick C

I would like to implement some functionality that would allow users to type
in data in a text box in an Access form which would automatically populate
other relational data in other text boxes within the same form. For
example, if I have a table which contains "Job" and "Part" columns, I would
like to be able to enter a job name and automatically populate the part that
corresponds to that job in the field below. How would I achieve this? I
have been working with MS Access 2000 as a technical user and most recently
as a developer.

Thank you in advance for any advice you may be able to offer. I hope my
explanation has been adequate.

Nick C.
 
A

Ayelet

try setting the Job_Ctl After_Update event so that it sets
the Part column accordingly.
HTH, Ayelet
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top