Current Record

M

Mike Revis

Access 2000 Win 2000 pro
Sorry, I couldn't think of a good subject.

frmOrders opens frmProducts.
frmProducts has a subform sfrmProductDetail.
An order record can have many product records.
A product record can have many sub productdetail records.

I have a command button located on frmProducts to preview a report.

I have code in the onclick event of the command button to check if
sfrmProduct.fieldA (text datatype) is equal to 3 then
sfrmProductDetail.fieldB (numeric data type) must have a value in it.

btw if sfrmProductDetail.FieldA is not equal to 3 then
sfrmProductDetail.FieldB is disabled.

The code only catches the error if the sfrm with the error is the current
record.

I think I know that I have to check the entire currentorder recordset but I
don't quite know how to start.

As always all advise and sugestions are welcome.

Mike
 
Top