message box when parameter is not found using update query

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

Guest

I use an update query to change data in one field after a parameter finds the
one requested record. How can I get a message box appearing, telling me that
no record was updated since no record was found using this parameter?
 
If you are using a macro to run the query, I can't help much because I don't
use macros enough to know how to test conditions in them; however, if you use
VBA to run the query, you can use the DLookup to test for the value before
you run the query
 
Back
Top