One field refencing another field

[norgren123]

I've been handed an interesting problem to solv

I have a database containing a series of names, part numbers, an
their location. I have created a form to add records to a table i
the database telling who took what part and on what date. The name
number, and location infromation is stored in another table an
referenced in the form. I have been trying to create a text box o
the form that basically shows the location of the part number when i
is selected. I have a tried several ways to solve this problem, bu
the only solution I seem to be stuck with is creating an "i
statement" for every part number and it's location. Is that the onl
way for me to do this

 

[Klatuu]

An If statement for each part number would probably be the worst possible way
to do that. Also, I saw another answer that suggested a subform. That would
be okay, except it is more work than necessary.

Just do a DLookup to find the part number and put it in the text box.