Payments Subform on a main Form question...

[Brook]

I have an invoice form that I use to track and maintain invoices and orders
for my company. Within the frminvoices is a frminvoicepaymentssubform that I
use for payments, what I am trying to do is set up a field within my mainform
(frminvoices) so that when my field (balance due) on my
frminvoicepaymentssubform, is "0" then a field on my main form "Paid in Full"
is populated as well as with the date of the final payment date which is a
field on the frminvoicepaymentssubform called "paymentdate" .

Is this possible?

I hope my explaination is clear...

Thanks

Brook