I have a table, which contains a combo box called ‘Complaint Type’ that allows the user to select ‘Claims Issues’ or ‘Contract Issues’. This table also contains yes/no fields that relate to the complaint type chosen. A few are CL-Claim Denied, CL-Claim Paid, CT-Contract Terminated, and CT-New Contract. I built a form, and I am trying to write code that will only display the yes/no check boxes that are associated with the complaint type chosen. For example, if the user selects the complaint type ‘Claims Issues’, I want only the yes/no check boxes CL-Claim Denied, and CL-Claim Paid to appear on the form. If the user selects ‘Contract Issues’, I only want to see ‘CT-Contract Terminated’ and ‘CT-New Contract’ on the form.
I know my sorry attempt at writing the code is missing quite a bit?.can anyone pleeeease help me with this? Thanks!!!
Private Sub Complaint_Type_Category_Codes_Click()
If Me.Complaint_Type_Category_Codes = “Claims Issues” Then
CL-Claim Denied.Visible = True
CL-Claim Paid.Visible = True
If Me.Complaint_Type_Category_Codes = “Contract Issues” Then
CT-Contract Terminated.Visible = True
CT-New Contract.Visible = True
Else
CL-Claim Denied.Visible = False
CL-Claim Paid.Visible = False
CT-Contract Terminated.Visible = False
CT-New Contract.Visible = False
End If
End If
End Sub