Need a 'tick all' control on my form

[Gina G]

A section of my database stores results from survey forms. Most
questions are answered yes or no. For these we have used check-boxes and
that works fine. The results for most forms are yes with occasional no
answers. Our Quality Assurance Policy prevents us from having the forms
ticked as yes by default therefore each form must be individually
selected to yes. I would like to be able to have a control to select all
to yes and then untick the no answers. This would speed things up and
reduce form errors. I don't know how to go about this.

Any help on this is very much appreciated

With Thanks
Gina G

[Chuck]

On Sat, 01 Nov 2008 20:45:35 GMT, Gina G <GG******@hotamil.comwrote:

>
A section of my database stores results from survey forms. Most
questions are answered yes or no. For these we have used check-boxes and
that works fine. The results for most forms are yes with occasional no
answers. Our Quality Assurance Policy prevents us from having the forms
ticked as yes by default therefore each form must be individually
selected to yes. I would like to be able to have a control to select all
to yes and then untick the no answers. This would speed things up and
reduce form errors. I don't know how to go about this.

Any help on this is very much appreciated

With Thanks
Gina G

You can make the 'On Open' event for the form check all boxes then you can
manually uncheck the ones that are supposed to be No. However, I'll bet that
your Quality Assurance Policy will not like that either. They want you to have
to 'think' about every answer. Also only unchecking some boxes is not likely
to have any fewer errors and could possibly result in more errors. Faster is
not always better.

Chuck
--

[Tony Toews [MVP]]

Chuck <li*****@schoollink.netwrote:

>You can make the 'On Open' event for the form check all boxes then you can
manually uncheck the ones that are supposed to be No. However, I'll bet that
your Quality Assurance Policy will not like that either. They want you to have
to 'think' about every answer. Also only unchecking some boxes is not likely
to have any fewer errors and could possibly result in more errors. Faster is
not always better.

I'm with Chuck on this one.

I recall a friend doing an audit on maintenance records for fire apparaturs for a
city fire dept. He said the guy didn't even bother to change pens when he wrote up
the various forms just before Don visited.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/