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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
List subform items on main form 2
find record in main form then find record in the subform 7
select record based on record selected in the child form 4
DMAX 5
RecordsetClone on a subform 3
OpenForm and Navigate to Subform Record? 1
showing a subform based on the main form 5

Top