update query

[Lior Montia]

Hi,

I have a button in a form that "on click" occurred
DoCmd.OpenQuery ("my_update_query")

How do I run this update query without any questions or messages ? just to
do the update and that's all.

Thanks.

 

[Jason Lepack]

currentdb.execute "my_update_query", dbfailonerror

 

[Douglas J. Steele]

Actually, assuming that my_update_query is the name of a stored query, I
believe you need to use:

Dim qdfUpdate As DAO.QueryDef

Set qdfUpdate = CurrentDb.QueryDefs("my_update_query")
qdfUpdate.Execute dbFailOnError

If you knew the SQL of that update query, then you could use the Execute
method on the Database object.