Re: Hiding Message Boxes?

Use CurrentDb.Execute instead:

CurrentDb.Execute "clear", dbFailOnError

"HowardChr" <u33744@uwe> wrote in message news:715734f56a300@xxxxxx
I have my program set up so that when a button called "Clear" is clicked,
it
clears all Yes/No fields from a seperate table. The problem is that when
that button is clicked, it is coming up with 2 seperate message boxes
making
sure that is what they want to do. The first one says: "are you sure you
want to run that query", and the second says "You are about to update 1
row".

Is there a way to code this so those message boxes are either
automatically
defaulted to Yes, or to have them run on the background? I dont' think my
VP
of IT would appriciate having to click 2 more times on each form.

Current code:

DoCmd.OpenQuery ("clear")

Thanks in advance!



.

Quantcast