Select All Query

[Guest]

i have a query and form that i setup. They query/form has 10 check boxes and
10 fields that display a value if the check box related to that field is
selected. I now want to able to setup a check box that will select all of the
other checkboxes at once if all the criteria applies. Is there a statement i
can put in the query that will allow me to do this?

check boxes name: Errorpts1BOX thru Errorpts10Box
Value field name: Errorpts1 thru Errorpts10

The statement i am using right now for each of the check boxes is

Abs([Errorpts1BOX])*5 and so on.

Any help is appreciated...

Thanks

 

[Steve Schapel]

Ray,

It sounds like what you really need is a little command button on your
form to set the value of all the checkboxes at once. The procedure on
this command button's Click event could be an Update Query, for example...
CurrentDb.Execute "UPDATE YourTable SET Errorpts1Box = -1,
Errorpts2Box = -1, Errorpts3Box = -1 ... etc WHERE YourID=" & Me.YourID

.... or the "brute force" approach, for example...
Me.Errorpts1Box = -1
Me.Errorpts2Box = -1
...
Me.Errorpts10Box = -1