Hi! Anyone know how to keep the me

[Dawnit]

Hi! Anyone know how to keep the message box from coming up when you click a command button on a form to run an update query? The message is, "You are about to run... "

Thanks!

 

[xburgler]

You have to disable de query update confirmation. In access 97 try:

Application.SetOption "Confirm Action Queries", False

Jorge

 

[TURNERMICH]

DoCmd.SetWarnings False
stDocName = "Macro3"
DoCmd.RunMacro stDocName
DoCmd.SetWarnings True

 

[TURNERMICH]

Sorry. In Click Event of the button, , add the code..
DoCmd.SetWarnings False
stDocName = "Macro3"
DoCmd.RunMacro stDocName
DoCmd.SetWarnings True

 

[Dawnit]

Is is true that the DoCmd.SetWarnings False... will turn off ALL warnings, message boxes?

Thanks for the info!