Check Boxes

[manic]

Hello All, I have a question about a form that I have.
The Form that I have for work , has 10 questions and 10 check boxes to answer the questions. Now my question is the following: "Is there a way or a code that when the user clicks the save button access will check is there are at least 3 check box that have been selected, any three, just to prevent the user from saving a form with only one or two check boxes selected?
Any help will be appreciated it.

[R_Badger]

There is use the beforeupdate event, and code something like this:

dim checks as integer
checks=0
if [checkbox1]=true then
checks=checks+1
endif
if [checkbox2]=true then
checks=checks+1
endif
if [checkbox3]=true then
checks=checks+1
endif
if [checkbox4]=true then
checks=checks+1
endif
if [checkbox5]=true then
checks=checks+1
endif
if [checkbox6]=true then
checks=checks+1
endif
if [checkbox7]=true then
checks=checks+1
endif
if [checkbox8]=true then
checks=checks+1
endif
if [checkbox9]=true then
checks=checks+1
endif
if [checkbox10]=true then
checks=checks+1
endif
if checks<3 then
me.cancel=true
msgbox "you must select at least 3 checks to continue"
endif

[Missinglinq]

...use the beforeupdate event...

BTW, that's the Form_BeforeUpdate event.

Linq ;0)>

[R_Badger]

Thanks Missinglinq! I don't know where my head is today!

[Missinglinq]

I always add that because the newbies we usually see here frequently don't realize that the Form has its own BeforeUpdate event, and will insist on using one of the Control's events, instead!

Linq ;0)>

[manic]

thanks guys, I appreciate the help.