Visibility based on Combo selection

[jlclark4]

Hey!



I would like the Compliance to become visible only if Written or Email is selected from the Method of Reciept and Yes is checked for the Official Complaint. Is this possible? I would need Official Complaint to be visible at all times.


Attached is a sample database with the basic setup.

[TheShabz]

I dont have Access available right now to look at but if "Written" and "Email" are combobox values and Official Complaint is a checkbox, you simply need to set the "visible" property of Compliance to "no" as the default. Then on the afterUpdate event of the combobox, do:

If Me.comboName= "written" AND Me.checkName = -1 OR Me.comboName= "email" AND Me.checkName = -1 Then
Me.Compliance.Visible = True
Else
'nothing
End If

also set this as the afterUpdate of the checkbox.