Using Drop down to search form

[CanWest]

I have a form that has a control to search the table for a specific record
See code below that is on the AfterUpdate event of a Combo Box

    Set rs = Me.Recordset.Clone
    rs.FindFirst "[ClientID] = " & Str(Nz(Me![cboName], 0))
    If Not rs.EOF Then Me.Bookmark = rs.Bookmark
    Me.cboTelephone = Null
    Me.cboName = Null

The source row of the combo box is

SELECT tblClients.ClientID, [LastName] & ", " & [FirstName] AS FullName
FROM tblClients
ORDER BY tblClients.LastName;

Note that the rowsource is from a table

I have several prebuilt filters that the user can use.

What I need to know is how to make the rowsource based on the filter and not the table. Any ideas would be greatly appreciated.

 

[CJ_London]

in yoru combo after update event put

me.filter="[ClientID] = " & Str(Nz(Me![cboName], 0))
me.filteron=true

 

[CanWest]

That did not work.

It still lists ALL of the records not just the filtered ones


I placed this at the end of my existing code. Should it have been at a different spot.

 

[CJ_London]

it replaces your existing code - if you put it after, you have set cboname to null by then

 

[CanWest]

it replaces your existing code - if you put it after, you have set cboname to null by then

Yup. That did it

Thank you