Anyone have a suggestion

S

S Tuttle

I have a table that I want to input the part name and then go to another
table and get the part number and code and automatically put that information
into the two field of the table that I am working in.
 
D

Dennis

You need to use a form to enter the data into your table instead of entering
directly into the table itself. The control source of the part number and
code fields on your form can then be set to
=DLookUp("[Part Number]","Parts Table","[Part Name] = '" & PartName & "'")
=DLookUp("[Part Code]","Parts Table","[Part Name] = '" & PartName & "'")
 
Top