update query creates prompts

  • Thread starter Thread starter Daniel M
  • Start date Start date
D

Daniel M

I have a similar problem as a question posed earlier.

I have a hidden text box with the default value of 'open' when ever i click
a button to write the data it submits open in the table and all is good. I
now have to be able to close it with a different button. If i run and update
qry it prompts me, am i sure i want to update the table, etc.

Is there a better way of doing this?

I have 2 cmd buttons, one opens, one closes. I want this to be automatic so
that i dont have to make a dropdown to select the status.

thanks.
 
if you're doing this in VBA code, using DoCmd.OpenQuery, then you can turn
the warnings off, run the query, and turn warnings back on, as

DoCmd.SetWarnings False
DoCmd.OpenQuery "MyQueryName"
DoCmd.SetWarnings True

or you can use the Execute method, as

CurrentDb.Execute "MyQueryName", dbFailOnError

hth
 
Back
Top