Datasheet subform Link
(I have not done any Access in a while and have forgotten some simple stuff!)
Table tblCUstomers has one record for many records in tblMessages
Run StartForm which shows 2 sub forms.
What I Want:
Example: If I click on CustomerID=1 on the upper form then I want the lower form to display multiple records where tblMessages.CustomerID=1
My problem at the moment is that the lower form displays ALL records (which is incorrect).
WealthMan.accdb
Table tblCUstomers has one record for many records in tblMessages
Run StartForm which shows 2 sub forms.
What I Want:
Example: If I click on CustomerID=1 on the upper form then I want the lower form to display multiple records where tblMessages.CustomerID=1
My problem at the moment is that the lower form displays ALL records (which is incorrect).
WealthMan.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You are welcome!
/gustav
/gustav
ASKER