M
magicdds
I have a form with the following subforms:
Subform1 - has a list of procedures that a client was charged for and the
fee for each procedure
Subform2 - is linked to subform1. It has the following fields:
PaymentPerInterval
NumberOfPayments
OptionGroup: To select if payments are to be made Monthly, Quarterly,
Annually, or Custom payment plan.
Subform3 - is linked to subform2. It has the following fields:
IntervalNumber
Due Date
AmountDue
When you click on a command button in subform2, records are created in
subform3 for each monthly or quarterly payment, to pay off the charge in
subform1. Each record is filled with the approprite due date and amountdue.
This all works fine for monthly, quarterly, and annual payment options
because the entire fee is divided into equal payments all at once. The
problem is with the custom payment option.
If there are two charges in subform1, one for $300 and a second for $1000
and the user wants to schedule a payment plan for the $1000 charge, the user
types in 5 payments of $100 in subform2, then 5 records are created in
subform3. Next the user could type in subform2, 10 payments of $50, and that
would create 10 additional records in subform3, to pay off the balance of the
$1000. But if inbetween typing the information for the $100 payments and the
$50 payments in subform2, the user clicks on the $300 charge in subform1, the
records in subform2 & 3, while still saved, have not been completed. The user
should not be able to leave the creation of a custom payment plan until it is
completed.
How can I prevent the user from navigating away from the creation of a
custom payment plan, until it is completed? This goes for navigating to
subform1 or any other text boxes or pages on the form.
Thanks for any ideas.
Mark
Subform1 - has a list of procedures that a client was charged for and the
fee for each procedure
Subform2 - is linked to subform1. It has the following fields:
PaymentPerInterval
NumberOfPayments
OptionGroup: To select if payments are to be made Monthly, Quarterly,
Annually, or Custom payment plan.
Subform3 - is linked to subform2. It has the following fields:
IntervalNumber
Due Date
AmountDue
When you click on a command button in subform2, records are created in
subform3 for each monthly or quarterly payment, to pay off the charge in
subform1. Each record is filled with the approprite due date and amountdue.
This all works fine for monthly, quarterly, and annual payment options
because the entire fee is divided into equal payments all at once. The
problem is with the custom payment option.
If there are two charges in subform1, one for $300 and a second for $1000
and the user wants to schedule a payment plan for the $1000 charge, the user
types in 5 payments of $100 in subform2, then 5 records are created in
subform3. Next the user could type in subform2, 10 payments of $50, and that
would create 10 additional records in subform3, to pay off the balance of the
$1000. But if inbetween typing the information for the $100 payments and the
$50 payments in subform2, the user clicks on the $300 charge in subform1, the
records in subform2 & 3, while still saved, have not been completed. The user
should not be able to leave the creation of a custom payment plan until it is
completed.
How can I prevent the user from navigating away from the creation of a
custom payment plan, until it is completed? This goes for navigating to
subform1 or any other text boxes or pages on the form.
Thanks for any ideas.
Mark