Automating an Update Query

[rosenn]

I have an update query that I use to calculate a particular value that is inserted into a table (Yes, I know I shouldn't do it this way but honestly there is no other way...I posted a prior question under the reports forum on calculating a value in a report, if you are interested exactly why I must do it this way; bottom line it works really well and I have no reflexive errors) I want to automatically execute this Update query on opening a report that is based on a different query

I already have a DoCmd.OpenQuery "MADateUpdater" that runs the update query on the event the report is opened; my report comes out perfectly. The problem is that the user is given two dialog boxes (automatically by Access) - one to acknowledge we will be updating data in a table, and a second box after all records are updated. I don't want my user to see these boxes or have to click "Yes" then "OK". I want to automate this.

Any ideas?

 

[Mile-O]

Edit your code thusly,

With DoCmd
   .SetWarnings False
   .OpenQuery "MADateUpdater"
   .SetWarnings True
End With

 

[rosenn]

works great

That did the trick.