I need some help with filtering.

I have a form based on a table. On this form I have combo boxes. Depending on the selection information will be displayed in a subform.

One of the combo boxes is getting it's record source from a lookup table which lists hardware types such as Printer, Workstation etc.. I have put the following filter in the afterupdate event for the combo box:

Private Sub Combo26_AfterUpdate()

' Filter the recordset

Me.Filter = "[HardwareType] = '" & Me![Combo26] & "'"
Me.FilterOn = True

End Sub

This works. Sort of. It will only display the first record, not all records of the same hardware type. So, I'm obviusly doing something wrong.

Any suggestions on how to fix this is very much appreciated.