udate query running on form close

  • Thread starter Thread starter Greg Clements
  • Start date Start date
G

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!.
 
You know... I've tried this before too, and I don't remeber whether or not I was very successful at the attempt. If you haven't tried this

Stored Procedure.
 
Greg,

Modify your code to this:

DoCmd.SetWarnings False
DoCmd.OpenQuery "NameOfYourUpDateQuery"
DoCmd.SetWarnings True
 
Back
Top