matt beamish
Registered User.
- Local time
- Today, 09:47
- Joined
- Sep 21, 2000
- Messages
- 208
Hi folks. I run a membership database where I use a bunch of nested queries to show who has paid/not paid their subs in a given year, and also who has overpaid and underpaid. I then set my membership forms recordsource to be the result of these queries. This is good for filtering the data, but invariably ends up with non-editable data in the forms due to the complex queries running to generate the data. I think what I need to know how to do, is to create a temporary table that just includes the MemberIDs in any given query, and use that to match against the membership table so that I can then edit the form data.
Currently I have a form button, 'Unpaid Current Year' which on click runs On event: Me.RecordSource = "Q_CY_Not_Paid"
My membership table is "T_Membership_details".
Hope this makes sense.
thanks
Currently I have a form button, 'Unpaid Current Year' which on click runs On event: Me.RecordSource = "Q_CY_Not_Paid"
My membership table is "T_Membership_details".
Hope this makes sense.
thanks