Error check

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Updating tables when you input new data 0
Use VBA Code to Assign Macro Buttons to use Different Queries for Source in a SubForm 0
COPY SUBFORM VALUE TO MAIN FORM 9
Parameter Value error in a Subform 0
Select All Button...Select all items in a subform once clicked 1
If query/subform is empty set calculation value to 0 4
Form_BeforeDelConfirm: Checking Values In Record TB Deleted? 1
Opening Internet Explorer submits incomplete record 2

Back
Top