Prev: How can I allow hyphen (or dash) in this validation rule?
Next: Code not giving the correct results
From: Revned on 6 Mar 2010 06:20
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


 | 
Pages: 1
Prev: How can I allow hyphen (or dash) in this validation rule?
Next: Code not giving the correct results