linking data items on a form

[Stacy Ouellette]

Bill,
You need to pull the data in with a query. When you
select the drop down then the description is populated.

 

[Bill]

Thanks Stacey,
but how do I get the query to run from the form??
Bill

 

[Rick Brandt]

OK Stacey,
I have discovered "action queries" in my book.
Thanks

No no no. An update query is not what you want.

You create a select query that pulls in the data from the second table and bind your
form to the query.