Disabling Pop-Up MessageBox for Record Operations

[robben]

I have a form and when a user wishes to update/delete a record for example I have created a pop-up box asking for confirmation of the operation before it commences. I'm currently using DoCmd.RunSql("UPDATE.... , when the
user clicks on yes, a new pop-up box appears which is autogenerated by Access stating "You are about to update 1 row(s)". Naturally this is not what I wanted, therefore my question is how do I prevent this message from appearing?

Thanks for your help.

 

[mhartman]

Hello:

You need to disable the "SetWarnings" setting to dispense with the Access standard warning messages.

Regards
Mark

 

[pbaldy]

You could also use

CurrentDb.Execute "UPDATE..."

which is supposedly more efficient anyway, and does not generate the warnings.

 

[robben]

Cheers guys!