Run query without confirmation from user

[ramnewbietoaccess]

I have an on close event for a form that runs a make table query and then an update query. Does anyone know how to alter the code so that it does not require the user to click yes 6 times?

Thank you in advance for advice or suggestions.

 

[Phantazmo]

You can use the SetWarnings method.

ie.

private sub RunQueries()

  docmd.SetWarnings false
  <run your queries>
  docmd.SetWarnings true

end sub

hope this helps

 

[ramnewbietoaccess]

Phantazmo thanks a lot!!!!!!!!!!!!! My end users HATE clicking 6 times lol dont blame them