Eliminationg a confirmation prompt

[Salisar7]

Is there a way to eliminate the confirmation window that pops up after a command like the following:

DoCmd.RunSQL "UPDATE [your table] SET [field A]=False, [field B]=True"

I have a command like this imbedded in the code for a button click and would like the confirmation prompt not to appear.

TIA

 

[PHV]

Have a look at the DoCmd.SetWarnings method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Salisar7]

Thanks much. That was exactly what I needed