subforms

[Revned]

Hello everyone,

I have two subform in my mainform, frmOrder and frmPayments with
record source of a select query.

I have this field in my tblOrder
CustomerName Date RefNo Amount

Primary Key RefNo

I have this field in my tblOrder
CustrName DatePaid RefNoPaid Amount

Primary Key

RefNoPaid

that is how I build my tables and query them.
I am planning that when in my frmOrders will automatically
set the checkbox field set to YES when the payment from frmPayments subform
equals to the amount from frmOrders? is it possible?

Hopefully this is clear..

Thank you in advance