I have a form which allows me to list an account's numerous invoices and then allocate a payment against them. The form is a continuous form and I have the following fields.
The main field on the form is the 'amountpaidfield' field, then listed on the subform I have, among others, the following fields, 'amountoutstandingfield', 'amountpaidoffinvoicefield'. On the subform footer i have the 'totalpaidoffinvoicefield'.
The code I have working (simplified) is " if the amount of the current invoice is equal to or less than the 'totalpaidoffinvoicefield' + 'amountoutstandingfield' then 'amountpaidoffinvoicefield' = 'amountoutstandingfield'.
The problem I have is if I press the payment button or alt P too quickly or if I hold the keys down the payments are set against the invoices straight away and the calculation doesnt get chance to work. I have tried various requery and refresh statements but the quick pressing of the keys bypasses them all.
I would appreciate any ideas anyone may have.
Thanks
MU
The main field on the form is the 'amountpaidfield' field, then listed on the subform I have, among others, the following fields, 'amountoutstandingfield', 'amountpaidoffinvoicefield'. On the subform footer i have the 'totalpaidoffinvoicefield'.
The code I have working (simplified) is " if the amount of the current invoice is equal to or less than the 'totalpaidoffinvoicefield' + 'amountoutstandingfield' then 'amountpaidoffinvoicefield' = 'amountoutstandingfield'.
The problem I have is if I press the payment button or alt P too quickly or if I hold the keys down the payments are set against the invoices straight away and the calculation doesnt get chance to work. I have tried various requery and refresh statements but the quick pressing of the keys bypasses them all.
I would appreciate any ideas anyone may have.
Thanks
MU
