automate update query

[Greg Clements]

i have an update query i want to run when i close a form,
i want to know if there is a way to bypass the 2 pop up
screens that ask question about running the query, i was
going to try the sendkeys command running in the form
before closing it but the pop ups still occur, i know
this has to be something simple, I am just missing it,
any help would be great!.



Greg

 

[Guest]

nope still get the pop up windows.

 

[Van T. Dinh]

Use the Execute Method to run the Query.

Exceute will run silently without warnings.