wrong data showing in form

  • Thread starter Lori2836 via AccessMonster.com
  • 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!
 
G

Guest

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form for Parts-Tools Lists 0
Access Automatically Send a notification email once a record is added 0
Filling in fields to a partially complete record in a table using a form 0
Prompt for a subform text field 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Create Form, using query with two parameters 4
Insert Associated Records to Subform 2
transfering data 3

Top