Main form shows record for every subform record.

M

Matt W.

My main form shows account information and my subform shows payment
information. I have one record for account information (main form) and 3
transactions for payment info (subform). The problem I am having is my main
form shows 3 records when there is in fact only one. I think I have a link
problem. any help is appreciated.

Thanks
 
G

Golfinray

You should have a one-to-many query as the basis of the form/subform and the
mainform is always the one, the subform is always the many. If you have the
wizard build the subform for you, it will ask you to pick what you want
linked. The link needs to be something common to both, like an id number or
account number. To check your link, click on the form and check properties.
 

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

First Subform record gets modified when closing form 3
Filter on Subform Not Displaying as Expected 1
Unremovable horizontal scroll bar on subform 1
Access Main form/Subform Navigation 0
Combo box search from main form to subform 1
Using form and subform not connecting to two separate tables 0
Pop-Up Subform not linking to Main Form 2
Subform to Main Form Record Problem 1

Top