SQL statement

[TTThio]

Hi again,

I don't understand what's wrong, need help with this:

button_click() - in frm1

strSelect = frm1.txt1
strSQL = "Select * from query1 where [name] = " & strSelect
or strSQL = "Select * from query1 where [name]= " & strSelect&""

set rs = db.openrecordset (strSQL)
msgbox rs.recordcount

None of the two strSQL above returns result. I forgot which one even returns error "too few parameter, expected 1"

Yet, if change the Where criteria [name] = 'text', it does return record.

Can anyone help me?

Thanks,
Tin Tin

 

[TTThio]

My mistake, I got it:

strSQL = "Select * from query1 where [name]= "' & strSelect&"'"