I want to enable/disable certain fields when a checkbox is ticked. I have put in the following coding in the "After Update" bit but it doesn't seem to work. Am I putting it in the wrong place or is just because my coding just really bad?
If Me.Member = True Then
Me.Member_ID.Enabled = True
Me.tbl_Appointment_First_Name.Enabled = False
Me.tbl_Appointment_Surname.Enabled = False
Me.tbl_Appointment_Contact_Number.Enabled = False
Else
Me.Member_ID.Enabled = False
Me.tbl_Customer_First_Name.Enabled = False
Me.tbl_Customer_Surname.Enabled = False
Me.tbl_Customer_Contact_Number.Enabled = False
Me.tbl_Appointment_First_Name.Enabled = True
Me.tbl_Appointment_Surname.Enabled = True
Me.tbl_Appointment_Contact_Number.Enabled = True
End If
Any help would be much appreciated, thanks!!
If Me.Member = True Then
Me.Member_ID.Enabled = True
Me.tbl_Appointment_First_Name.Enabled = False
Me.tbl_Appointment_Surname.Enabled = False
Me.tbl_Appointment_Contact_Number.Enabled = False
Else
Me.Member_ID.Enabled = False
Me.tbl_Customer_First_Name.Enabled = False
Me.tbl_Customer_Surname.Enabled = False
Me.tbl_Customer_Contact_Number.Enabled = False
Me.tbl_Appointment_First_Name.Enabled = True
Me.tbl_Appointment_Surname.Enabled = True
Me.tbl_Appointment_Contact_Number.Enabled = True
End If
Any help would be much appreciated, thanks!!
Last edited: