help checkboxes

[bhavinnp]

i need to know how to do this:
if all checkbox on form are unchecked then msgbox("please select one")
else goto form2

[bushmobile]

As long as they're bi-state checkboxes:

If Not CBool(Check1.Value Or Check2.Value Or Check3.Value) Then
    MsgBox "Please Select One"
  Else
    ' Go to Form2
  End If

[Nida]

if check1.value=0 Or check2.value=0 then
MsgBox "Please Select...... "
end if

[Bruce Fox]

Taking both examples and using VB Intrisic Constants:

If Check1.Value = [b]vbUnChecked[/b] And Check2.Value = vbUnChecked  And Check3.Value = vbUnChecked Then
    MsgBox "Please Select One", vbOkOnly + vbInformation, App.EXEName
  Else
    ' Go to Form2
  End If