update a subform A from subform B based on MinPaymentField

B

Brook

good day all..

I have an invoices form with a invoicedetails subform and invoicepayment
subform. On the invoicedetails subform I have a yes/no field called
paidinfull, and invoicepayments subform I have the following field:

MinPaymentAmt=DMin("[amountdue]","tblinvoicepayments","[invoiceid] = " &
[invoiceid])

I want to be able to update the Paidinfull field to "True" when the
MinPaymentAmount is equal to '0'...

I have tried and tried... but no luck can anyone point me in the right
direction.. with any tips or suggestions?



thanks,

Brook
 
Top