Filter from 2 Combo Boxes

[JimO]

Having a problem getting this to work. I have tried a number of variations but it has been by trial and error.


Any ideas would be appreciated.

   Me.Filter = ""
    Me.FilterOn = False
    Me.Filter = "[ConstCmb].[Column](0) = '" & Me.[ConstructorCmb].[Column](0) & "' "
    Me.FilterOn = True

Source for both [ConstCmb] and [ConstCmb];

SELECT [ConstID], [Constructor] FROM AutoConstructorT ORDER BY Constructor;

Run-time error '3709'
The search key was not found in any record.

Thanks
Jim O

[ssanfu]

Not quite sure what you are trying to do, but maybe this will help.

When you are setting a filter, you are picking a FIELD in the form record source to limit records.

It looks like the field "ConstID" is the PK field for the table. If so, then setting a filter using "ConstID" will return one record.


Here is an example for filtering on "ConstID":
(assuming "ConstID" is a number type field)

    Me.Filter = ""
    Me.FilterOn = False
    Me.Filter = "ConstID = " & Me.ConstCmb '(usually, the first field is the bound field, so the ".Column(0)" is not needed)
    Me.FilterOn = True

Here is an example for filtering on "Constructor":
(assuming "Constructor" is a text type field)

    Me.Filter = ""
    Me.FilterOn = False
    Me.Filter = "Constructor = '" & Me.ConstructorCmb.Column(1) & "'"  '(brackets not needed - you are referring to a control on a form, not a field)
    Me.FilterOn = True

[JimO]

Thank you very much for the help. It is doing what I wanted. I did change = to LIKE to show all records that fit the search criteria.


Thanks
Jim O