Continuous search form help - displaying text box values

[rasher]

I have a search form that is continuous, and uses tbxEmployeeID to identify the records that are displayed with the criteria selected. I want to use:

Private Sub btnPrint_Click()
'this object prints the results to a report

Dim strWhere As String
Dim lngLen As Long
strWhere = "" 'main filter

strWhere = strWhere & "[Employee_ID] LIKE ""*" & Me.tbxEmployeeID & "*"""

'insert print function
DoCmd.Minimize
DoCmd.OpenReport "Search Results", acViewPreview, , strWhere

End Sub

to display multiple records that are found in the data set, because the report I have cannot be linked with the other criteria (CertificationID, SkillID, etc). Searching for a certification or a skill brings up the employee anyway, so all I need is to be able to display the employee.

The function works fine, but the problem is that it only displays whichever employee is in the first text box. I need it to display all of the ID's found in the text boxes, and I'm not sure how.

Any ideas?