Hello,
I currently have a form I am designing in Access. I have a Check Box called [chkboxFollow-UpRequired]; this field is always visible. If the employee is filling out the form, and Follow-up is required, they will click on this check box. On Click; I have code build in to make 6 other fields appear below it.
Private Sub chkboxFollow_UpRequired_Click()
If Me.chkboxFollow_UpRequired = True Then
Me.txtFollow_upValidationOwner.Visible = True
Me.txtMethodofFollowUp.Visible = True
Me.txtFollow_upTestNumber.Visible = True
Me.txtFollow_upTestTargetPublication.Visible = True
Me.txtFollow_upCompletionRequiredby_.Visible = True
Me.txtFollow_upDateCompleted.Visible = True
End If
End Sub
This is working great. What I am trying to do now is; if the employee clicked the box on accident, they will deselect the check box; but those six fields are still there. How do I make those six fields disappeared again when the check box is deselect??
I currently have a form I am designing in Access. I have a Check Box called [chkboxFollow-UpRequired]; this field is always visible. If the employee is filling out the form, and Follow-up is required, they will click on this check box. On Click; I have code build in to make 6 other fields appear below it.
Private Sub chkboxFollow_UpRequired_Click()
If Me.chkboxFollow_UpRequired = True Then
Me.txtFollow_upValidationOwner.Visible = True
Me.txtMethodofFollowUp.Visible = True
Me.txtFollow_upTestNumber.Visible = True
Me.txtFollow_upTestTargetPublication.Visible = True
Me.txtFollow_upCompletionRequiredby_.Visible = True
Me.txtFollow_upDateCompleted.Visible = True
End If
End Sub
This is working great. What I am trying to do now is; if the employee clicked the box on accident, they will deselect the check box; but those six fields are still there. How do I make those six fields disappeared again when the check box is deselect??
