Try this.
Put a text box on your main form. In the CONTROL SOURCE of that put this:
=DSum("[amount owing]","levies","[MembershipNum] = " & [txtmembershipnumber])
VIP
Windows XP 
Access 2003
Try this.
Put a text box on your main form. In the CONTROL SOURCE of that put this:
=DSum("[amount owing]","levies","[MembershipNum] = " & [txtmembershipnumber])
Data entry subform: how to add a field in the record but not on subform
Can't Tie a Field In A Subform To a Field In Main Form (worked in 2003, not in 2007)
Posting Permissions
Reply With Quote