Filters in a form

[hansproperty]

I am trying to locate a record in a table using a set of three filters, the first one for a component type, the second for a model number, and the third needs to bring up a set of serial numbers based on the results of the previous filters. I have tried using combo boxes for the three filters, but they need to be unbound to prevent the records being altered. The problem is how do I select a record which is a function of Type, Model and SerialNo from three unbound combo boxes? It would be easy if the SerialNo was unique, but unfortunately many models have identical Serial numbers.

 

[jrbarnett]

In the afterupdate event of each of the comboboxes, put code similar to the following:

Dim strFilter As String

strFilter = Me.Filter ' record the filter details
' must edit line below to reflect data type, combo name and field name
strFilter = strFilter & " AND TYPE = '" & Me!cboType & "'"

Me.Filter = Mid(strFilter, 6) ' set filter to everything after character 6 (ie extract the AND 
Me.FilterOn = True ' and apply it.

John