Help with combo box on form

[bigguy]

I would really appreciate some help with a problem that I'm having.

I have a search form that has a combo box which a user selects a name from and that opens a results form with the data from that client.
Everthing works fine except that whatever name you choose from the combo box always opens the first record and not the selected one. My code for combo box On Change is

DoCmd.OpenForm "ResultsFrm", _
WhereCondition = "RecipientsName = " & Nz(Me.RecipientsName, 0), _


WindowMode:=acDialog

[June7]

Are you filtering on text name value or on number ID value?

Show the combobox properties:
RowSource
BoundColumn
ColumnCount
ColumnWidths

Use AfterUpdate instead of Change event.

[bigguy]

Are you filtering on text name value or on number ID value?

Show the combobox properties:
RowSource
BoundColumn
ColumnCount
ColumnWidths

Use AfterUpdate instead of Change event.

I'm using text name. My combobox value's are

Row source = MainTbl
Bound Column = 1
Column Count = 1
Columnwidths = Empty

[June7]

The RowSource is reference to a table. This will pull the first field. Is the first field an autonumber ID?

Better to have the RowSource explicitly select field(s) with an SQL statement.

Why use name as criteria? What if there is more than one Jane Smith? Use unique identifier such as CustomerID to filter records.