D
Dan Kline
Hi,
Please help with this simple request. I'm working on a volunteer project
and what I'm trying to do is very simple, yet I haven't found a good example
and I'm spending WAY too much time figuring it out.
I have a simple Database with members, Payments and payment details.
Actually, that's a little simplified. I have events, event types, member
types, membership groups, etc. etc., but we'll work with the primary
relationships for clarity.
Members make payments (PK = PaymentID) which contain a DepositDate and have
one or more deposit details. What I'd like to accomplish is to open a
form(DepositDateEntry) and return a date for the query upon which the data of
the form is populated. The Deposits form (Split Form with a form/subform at
the top and datasheet at the bottom) would call the DepositDateEntry Form
during the onLoad event then return and requery the underlying data. The
Deposit form would then retrieve the payments for the date and populate the
datasheet, retrieve the payment details (FK = PaymentID) for the first
payment record and populate the form/subform with the information from the
first payment for the deposit date. If no payments are found for a deposit
date, the form should open with a blank datasheet and default to "Insert"
mode with a new record.
This should be and probably is simple, but somehow I'm just not getting it.
Can anyone provide a very simple example?
Thanks
Please help with this simple request. I'm working on a volunteer project
and what I'm trying to do is very simple, yet I haven't found a good example
and I'm spending WAY too much time figuring it out.
I have a simple Database with members, Payments and payment details.
Actually, that's a little simplified. I have events, event types, member
types, membership groups, etc. etc., but we'll work with the primary
relationships for clarity.
Members make payments (PK = PaymentID) which contain a DepositDate and have
one or more deposit details. What I'd like to accomplish is to open a
form(DepositDateEntry) and return a date for the query upon which the data of
the form is populated. The Deposits form (Split Form with a form/subform at
the top and datasheet at the bottom) would call the DepositDateEntry Form
during the onLoad event then return and requery the underlying data. The
Deposit form would then retrieve the payments for the date and populate the
datasheet, retrieve the payment details (FK = PaymentID) for the first
payment record and populate the form/subform with the information from the
first payment for the deposit date. If no payments are found for a deposit
date, the form should open with a blank datasheet and default to "Insert"
mode with a new record.
This should be and probably is simple, but somehow I'm just not getting it.
Can anyone provide a very simple example?
Thanks