Can't get subform to show records for main form account.

G

Guest

I tried to add a subform to my main form but can not get the subform to show
only those records associated with the account on the main form. Instead it
shows every record in the table. The main and sub are made of one table
each. The two tables have a one-to-many relationship with the same data
types. I haven't used Access in a while and can not remember how to fix this
issue.
 
J

J. Goddard

sounds like you have not set the subform's Master Field link and Child
Field Link correctly, if at all.

John
 

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

Access Main form/Subform Navigation 0
First Subform record gets modified when closing form 3
Update subform with combobox change on main form 1
Subform with no records 8
Main form shows record for every subform record. 1
Subform to Main Form Record Problem 1
Main \ Sub Form Data 1
Using form and subform not connecting to two separate tables 0

Top