Main form shows record for every subform record.

Main form shows record for every subform record.

Post by TWF0dCBXL » Thu, 14 Aug 2008 23:03:01


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
 
 
 

Main form shows record for every subform record.

Post by R29sZmlucm » Fri, 15 Aug 2008 00:12:04

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.