Fill values in a table based on values in another table

[stotzc001]

I have a table that has a drop down list that is linked to another table. I have three fields in that first table that need to be pulled from the second table based on the value of the drop down list, and I am having trouble making it work.

 

[jdgreen]

Just a question for you, are you planning on saving the same information in both tables? If so why don't you set up a relationship between the two tables? If that is not the case you can use the dlookup function to populate the form.

John Green