can you get rid of pop up msg "you are about to run an update query.." 1

[wshm]

is it possible to get rid of msg "You are about to run an update query that will modify data in your table"?
My users are complaining to receive that msg and another post message "You are about to update ?? row(s).

It pops up 3 times because I have 3 update queries.
I tried to combine them but I get an error because of
relationships.

is it not possible to get rid of that msg?

 

[PHV]

Have a look at the DoCmd.SetWarnings method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[wshm]

it's like magic! thx PHV as always =)

 

[Ed2020]

My preferred method is to use CurrentDB.Execute to run action queries - mainly because it's less typing on my part (no need to turn warnings off and then to remember to turn them back on).

Another benefit is it allows for running in a transaction and then committing the changes to the database in one go, once you're sure they've all run successfully.

Ed Metcalfe.

Please do not feed the trolls.....