either / or type rule

[Toolpusher]

Hi

I have a form with many fields on it but I want to create a rule that if a certain check box is not ticked then at least one value must be selected from two combo boxs I have on the form. If the check box is selected this is not a requirement.

Any help appreciated

TP

 

[vbaInet]

Psedo-code:

If Checkbox is not ticked Then
     If Combobox1.ListIndex + Combobox2.ListIndex Is Less than 0 Then
           Msgbox "Please select at least one value in both combo boxes"
     End If
End If

This will go in the Before Update event of the form.

NB: You will also need Nz() for the Checkbox.