Combo Box Filtering issues

[MOCaseA]

I am trying to create a series of combo-boxes that filter the viewable records by the values listed. There are several combo-boxes per form and several thousand records that will be filtered. See attached screenshot for an example.


What I am trying to do is create a filtering rule that filters out all but the values selected in any/all the combo-boxes, while allowing navigation to all the records that match the criteria in the combo boxes.

Here is the very basic filtering rule I have created, but does not seem to be functioning:

Sub CAR_AfterUpdate()
    Dim rs As DAO.Recordset
 
    If Not IsNull(Me.CAR) Then
        'Save before move.
        If Me.Dirty Then
            Me.Dirty = False
        End If
        'Search in the clone set.
        Set rs = Me.RecordsetClone
        rs.FindFirst "[CAR] = """ & Me.CAR & """"
        If rs.NoMatch Then
            MsgBox "Not found: filtered?"
        Else
            'Display the found record in the form.
            Me.Bookmark = rs.Bookmark
        End If
        Set rs = Nothing
    End If
End Sub

I have used this code on all of my combo-boxes, substituting the appropriate references. I know very little about VB coding and it took me two days just to make this basic filter rule. On a form with a single combo-box this works great for navigating to specific records, but it doesn't work here. Please, any help would be wonderful. Thank you.

** Edit **

[jimatqsi]

Perhaps this will help. It is a bytes.com insight article by NeoPa explaining all you need to know about dynamic filtering of a form.

http://bytes.com/topic/access/insigh...filtering-form

Jim

[MOCaseA]

Thank you. I found that about an hour after I posted this, and the form is working correctly now.

[NeoPa]

I'm impressed that you realised to post your question in its own thread. I wonder if you realise though, that a link to that same article was already posted in the thread you asked the question in originally.

I'm only curious as I was planning to moderate your post anyway to move it to its own thread, but you did it for me. Saved me a job, which is always good :D

[MOCaseA]

Moved to a new thread...