wrong data showing in form

  • Thread starter Thread starter Lori2836 via AccessMonster.com
  • Start date Start date
L

Lori2836 via AccessMonster.com

Can someone help? I click on my Command button, which brings up a subform of
part numbers and pertinent information (which all comes from one query).
When I click on a part number, a form comes up (and should show) the info
for that part number in a form. But the info showing is the last info
entered into the table.....not the part number I'm clicking on. How do I
set it up so the info on whichever part I click on shows in the form?

Thanks for any help I can get!
 
Lori,
You may not need a command button to use a subform. Place the subform that
has the part details on your main form.
Open the properties of the subform.
Find properties "link master fields" and "link child fields".
Put Part number in both places (if that is the name of your linking field).
 
Back
Top