how to disable fields in subform or how to disale the subform

[kee2ka4]

Hello Everyone, in my access application, I have two tables that are

1. tblStudents where studentID is the pk (Primary Key)
2. tblExam where ExamID is the pk and fkStudentID is the foreign key

I have a form called students that displays information about a individual student and below I have a exam subform that Displays Exams taken by that individual student.

However I only want the Exam subform to be enabled if the user check the checkbox “Exam Taken”. So if it is not check that it should be disabled. Could anyone please guide me how do I go about doing that in VBA.

Thanks for all your help.
Ket

[ADezii]

Hello Everyone, in my access application, I have two tables that are

1. tblStudents where studentID is the pk (Primary Key)
2. tblExam where ExamID is the pk and fkStudentID is the foreign key

I have a form called students that displays information about a individual student and below I have a exam subform that Displays Exams taken by that individual student.

However I only want the Exam subform to be enabled if the user check the checkbox “Exam Taken”. So if it is not check that it should be disabled. Could anyone please guide me how do I go about doing that in VBA.

Thanks for all your help.
Ket

You need to place Duplicate Code in the Form's Current() Event and also in the AfterUpdate() Event of the [Exam Taken] Check Box as indicated below (replace subfChild with your SubForm Name):

Private Sub Form_Current()
If Me![Exam Taken] Then
  Me![subfChild].Enabled = True
Else
  Me![subfChild].Enabled = False
End If
End Sub

Private Sub Exam_Taken_AfterUpdate()
If Me![Exam Taken] Then
  Me![subfChild].Enabled = True
Else
  Me![subfChild].Enabled = False
End If
End Sub