set row source for list box in vba code?

[xq]

i was trying set row source by sql string in vba code for a list box, why when i open it, there is nothing, i use the same way to set up row source for combo box, it works fine, or the list box is different with combo box?

the code is:

Me!lstResult.RowSource = "SELECT Invoice.ID " & _
"FROM Invoice WHERR " & _
"Invoice.ID = " & & _
Form_SearchcmbInvoiceID

really appreciate for any help!!!

 

[KenReay]

Hi

Not sure if errors are actually in the code or just in what you copied here, But

Me!lstResult.RowSource = "SELECT Invoice.ID " & _
"FROM Invoice WHERR " & _
"Invoice.ID = " & & _
Form_SearchcmbInvoiceID

Me!lstResult.RowSource = "SELECT Invoice.ID " & _
"FROM Invoice WHERE " & _
"Invoice.ID = " & _
Form_SearchcmbInvoiceID

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reay@talk21.com

 

[pgk]

Hi,
If InvoiceId is a number, then try using the Val function to convert it into a number like:

Me!lstResult.RowSource = "SELECT Invoice.ID " & _
"FROM Invoice WHERE " & _
"Invoice.ID = " & & _
Val(Form_SearchcmbInvoiceID)

Me.lstResult.Requery Hope it helps. Let me know what happens.
With regards,
PGK