Run Query without popup

[Marceb]

Hallo

i am using a update query. and works fine. however i get these popup with the question if i am sure to update the table whit 21 records



is there a method to update the table automatically without the popup

[isladogs]

If running the query using code or a macro you can switch warnings off before running the query but do make sure you switch them back on afterwards.
It's also possible to switch off these warnings permanently in Access options but that is not recommended.

[MLogue9]

docmd.setwarnings (warningsoff)

[isladogs]

In VBA, just DoCmd.SetWarnings False followed by DoCmd.SetWarnings True

[orange]

Or in vba use this construct

currentdb.execute "your update query sql here",dbFailonError

Good luck.