I have the following code for a form with a checkbox:
If Me!ServiceWork And IsNull(Me!PrimaryBusiness) Then
Cancel = True
MsgBox "If Service Work is checked, Must Choose Primary Business.",
48, "Required Field"
Me!PrimaryBusiness.SetFocus
End If
End Sub
The above requires the user to choose a primay business if service work
box is checked. I want it to work backwards as well and am having some
trouble. If the primary business combobox is a value such as "Repair
Shop" then I want the servicework checkbox to be required. Please
help. Thanks.