Checkboxes - at least 1 MUST be...

[jamie_b]

Hi,

The application and form is setup so that the user can not close the form unless the custom 'SAVE' button is clicked.

'Save" button does various checks for valid field entries.

I have 3 seperate (not grouped) check boxes (0=not checked, -1=checked)

The user can check any one or two or all three checkboxes, but MUST check at least one of them. I cannot force the user to check a SPECIFIC box.

With the OnClick event of the 'save' button, I need to verify that at least one of the (non-grouped) boxes are checked.

Not sure what to do here. Any advice ?

Thank you.
Jamie.

 

[wazz]

check 'em.

if me.chk1 = 0 and me.chk2 = 0 and me.chk3 = 0  then
    msgbox "check one"
    exit sub
end if

 

[jamie_b]

check 'em.

if me.chk1 = 0 and me.chk2 = 0 and me.chk3 = 0  then
    msgbox "check one"
    exit sub
end if

so simple...

Thank You !