Run an update query without user confirmation 1

[SimonDavis]

Hi all,

I want to run an update query when a user loads a form.

It's to check fields to see how long ago they were updated, and flag 'out of date' with some criteria.

This (depending on how I finally code it) may involve several queries running one after the other.

How can I run them without it asking the user to confirm that the records will be updated. I know it is a dangerous thing to let the application run wild, but I'm aware of the implications. The user probably isn't and will just have to make unneccessary clicks.

Can it be done? Thanks.

 

[rjoshi2]

All you need to due is turn the warning on or off. Here is code to due so.

'turn warnings off
DoCmd.SetWarnings False

your code go in here

'turn warning on
DoCmd.SetWarnings True

rjoshi2

 

[SimonDavis]

So simple!

Many thanks for the help.