Suppressing warning messages from MakeTable query

[John S. Ford, MD]

I have a command button on a form than executes a MakeTable query using the
DoCmd.RunSQL method based on entered criteria. It works fine but creates a
table deletion warning and an "about to paste records" warning that I'd like
to supress because they're superfluous.

How can I do this? Can it be done without supressing other important
warning messages elsewhere?

John

 

[Lord Kelvan]

docmd.SetWarnings = False
'your code
docmd.SetWarnings = true

remember to set it back to true for other warnings after the fact

regards
Kelvan

 

[John S. Ford, MD]

Thanks Kelvan.