How can i do that the following prompt will not appear :
"You are about to update 11 row(s) . Once you click yes , you can't use the Undo command to reverse the changes . Are you sure you want to update these records ? "
?

Paula .

Hi, Paula,

If you're in VBA code, you can do this

DoCmd.SetWarnings False

Put your SQL code here.

DoCmd.SetWarnings True


Don't forget to reset it back to true! It's important!


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks!!!!!It worked!!!!!