filter combo box

[mkkashif]

Dim sbillno As String

sbillno = "SELECT [bill2].[autonumber] " & _
"FROM bill2 " & _
"WHERE [CustomerID] = " & Me.search.Value
Me.Billno.RowSource = sbillno
Me.Billno.Requery

i am using this code but there is problem of data type mismatch.
i have 2 combo box .
i want when customer id is select than the other combo box "sbillno" will select the record against the id
autonumber is a autonumber field and customer id is a text field.
i am facing the problem data type mismatch any body can help me.

 

[WayneRyan]

mkkashif,

Is "search" your other combo-box?

If it is you probably need to reference:

Me.search.Column(0)

It's probably a two-column combo: ID, Name
with ID invisible (width = 0).

Wayne