SteveL13

<div>
<div class="content wysiwyg-content">
On a form I have three checkboxes. &nbsp;At least one of them has to be checked. &nbsp;If the user hasn't checked at least one of them I want a message box to let them know they have to select at least one of them and not let them proceed. &nbsp; I tried this but it doesn't work because the user has to check all three.<br />
<br />
&nbsp; &nbsp; If Me.chkbxOne Or Me.chkbxTwo Or Me.chkbxThree = False Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; MsgBox &quot;You must select either One, Two, or Three.&quot;<br />
&nbsp; &nbsp; End If
</div>
</div>


On a form I have three checkboxes.  At least one of them has to be checked.  If the user hasn't checked at least one of them I want a message box to let them know they have to select at least one of them and not let them proceed.   I tried this but it doesn't work because the user has to check all three.

    If Me.chkbxOne Or Me.chkbxTwo Or Me.chkbxThree = False Then
        MsgBox "You must select either One, Two, or Three."
    End If

Check at least one of three checkboxes

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.