Checkbox Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have added a checkbox to one of my reports and depending on what other
checkboxes on my report are checked off I want the checkbox I added to either
be checked or unchecked.
Here is an example.

Physio FD Visit SMGH Visit FA Form Required
[ ] [ ] [ ] [x] [
]
[x] [ ] [ x] [ ] [x ]

I want the "Form Required" checkbox to be checked if anyone of the following
are checked off "Physio", "FD Visit", and "SMGH Visit". If just "FA" is
checked then I don't want "Form Required" to get checked.

This is what i have in the "Form Required" Control Source Property....
=IIf([Physio] Or [FD Visit] Or [SMGH visit],True,True)
But this makes the "Form Required" checkbox set to True(checked) all the
time, no matter what senerio.

Can anyone help me with my IIF statement.

Thanks in advance.
 
the forms control source may not be the right place.
you may need to create a sub for each check box.
here is code i wrote for such a situation.
Private Sub chkExEmp_Click()

If Me.chkExEmp = True Then
Me.chkOld = False
Me.ChkNegBal = False
Me.chkCurrent = False
End If

End Sub
here i just made sure that if the employee check was
checked, the other 3 checks were unchecked.
Private Sub chkCurrent_Click()

If Me.chkCurrent = True Then
Me.chkOld = False
Me.ChkNegBal = False
Me.chkDate = False
Me.txtDateInput.Enabled = False
Me.txtDateInput = Null
Me.txtEmpID.Enabled = True
Me.txtEmpName.Enabled = True
Me.txtEmpID = Null
Me.txtEmpName = Null
Me.txtEmpID.SetFocus
End If

End Sub
Here i was not only make sure the other check were uncheck
but disableing other controls on the form and clearing
text boxes.
You may need a sub for each one of your check boxes
stating what other checks should be check or uncheck if a
perticular check is checked or unchecked.
good luck
 
Back
Top