Error check

R

RichardT

I have a table with a status field with values of either "OK" or
"Incomplete". This table sits in a subform. I want to run an update process
(macro or VBA) on the main form, but I want the process to first check if
there are any values in the subform that are still set to "Incomplete" - if
so, then I would like to display an error message and stop processing.

Any ideas how to do this?

Thanks
 
V

Van T. Dinh

I guess you can get the (filtered) Recordset of the Subform and use
FindFirst (DAO Library required) to see if there is any row/Record in the
Subform's Recordset that has the value "Incomplete".

Alternatively, you can use a DCount() with criteria so that selected Records
are the same with the Records currently on the Subform with an additional
criterion to select only "Incomplete". If DCount() returns > 0, that means
Record(s) with "Incomplete" exist.
 
Top