Linking Fields at a Form! NEED HELP!

[FlavioT]

Hi!
I have tables that are related. At a first form I ask for the product code, date, quantity, etc that are all in TABLE1 and I want a text box to show the product name that is is TABLE2.
What I need is the code that when the users type the code the name of the product will show automatically in TEXTBOX1.

HELP PLEASE!!!!

 

[bat17]

If you join the two tables together in a query behind the form then the fields will show automaticaly.

HTH

Peter