title: Continuous SubForm Output based on Combobox Access 2010
body: <p>I'm trying to get a continuous subform, displaying CourseID and CourseCompletionDate, to display output related to the Employee chosen in through the main subform's combobox (this is an employee training profile showing what the employee's completed training on). Here's my VBA:</p>
  <pre><code>Private Sub cboEmployee_AfterUpdate()
      On Error GoTo Proc_Error
      If IsNull(Me.cboEmployee) Then
         Me.subEmployeeCourseTrainingCompletion.EmployeeProfile.Filter = &quot;&quot;
         Me.subEmployeeCourseTrainingCompletion.EmployeeProfile.FilterOn = False
      Else
        Me.subEmployeeCourseTrainingCompletion.EmployeeProfile.Filter = &quot;[EmployeeID]=&quot; &amp; Me.cboEmployee
        Me.subEmployeeCourseTrainingCompletion.EmployeeProfile.FilterOn = True
      End If
  Proc_Exit:
         Exit Sub
  Proc_Error:
         MsgBox &quot;Error &quot; &amp; Err.Number &amp; &quot; in setting subEmployeeCourseTrainingCompletion filter:&quot; &amp; vbCrLf &amp; Err.Description
         Resume Proc_Exit
  End Sub
  </code></pre>
  <p>Error that I get when trying to use the combobox on the main subform.
  <img src="https://i.stack.imgur.com/nvqV1.png" alt="Error that I get when trying to use the combobox on the main subform" /></p>
  <p>Why doesn't this want to work when switching employees in the combobox? How can I make this VBA and subform work flawlessly with the combobox?</p>