running a SQL Update without confirmation prompt from Access

[Nestor01]

using Access 2007. I would like to call a sql update query with a macro, but I want it to update without prompting or otherwise notifying the user. Anyone got any ideas on this?

[Rabbit]

In VBA code you use
DoCmd.SetWarnin gs False
SQL Stuff Here
DoCmd.SetWarnin gs True

I assume there's a similar thing for macros.

[Nestor01]

In VBA code you use
DoCmd.SetWarnin gs False
SQL Stuff Here
DoCmd.SetWarnin gs True

I assume there's a similar thing for macros.

huh, that's what the does....can't wait to try it!

[Nestor01]

That did it.....I'm using it to solve a record lock issue by updating a field each time a record is opened. very clean, simple fix.

Thanks.

[Rabbit]

Not a problem. Good luck.