Hello everyone,

I have a table tblOrders
CustomerName DateOrder RefNo Amount Status

primary key: RefNo
Field type: Status - check box

I have a table tblPayments
CustName Datepaid PaidRef AmntPaid

primary key: PaidRef

can anyone help me figure out how can I design my query and my form/subform
that when in my tblPayment field name AmntPaid equals to tblOrder field name
Amount, access will automaitcally set the field name Status to Yes.

please can anyone help me.

thanks in advance, i appreciate