append query message

AccessWater

Registered User.
Local time
Today, 11:42
Joined
Jun 14, 2006
Messages
52
Hello, I used a commond button to run a query in a form. This is an append query that appends the new setups in the form to a table. However, every time I click the button, a message come out: You are about to run an append query that will modify data in your table.

Since this is a form application, I do not want this message come out when I click the button. Can anyone tell me how could I stop this message come out when I click the button.

Thank you.
 
use Docmd.SetWarnings= False to turn off the warning messages.
 
Thank you very much, KeithG. It works. It is Docmd.SetWarnings false . No "=" .
 

Users who are viewing this thread

Back
Top Bottom