One field refencing another field

  • Thread starter Thread starter norgren123
  • Start date Start date
N

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
 
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.
 
Back
Top