CQ.SQL = "PARAMETERS something1 LONG; " & _
" SELECT * FROM TELEPHONE_DIRECTORY" & _
" WHERE EXTENSION_NO LIKE '[something1]%' " & _
" ORDER BY LAST_NAME, EXTENSION_No ; "
Public Sub Text1_change()
CQ![something1] = Text1.Text
.......
.......(more coding)

end sub
everything works if i change the sql statement WHERE EXTENSION_NO = [something1]

Are you using SQL Server?

If you were using Oracle, the query would be:

NOTE: ... EXTENSION_NO LIKE (single tick)(double tick) || something1 || (single tick)(double tick)%(single tick) ... in the variation of SQL you are using, you'll switch single and double tick use.

I wonder if the name of the variable is being put into your query instead of the value...

JoeB

NO JOY STILL

Access 2002,

Select *
from table
where column LIKE [param] &'*'

CQ.SQL = "PARAMETERS something1 string; " & _
" SELECT * FROM TELEPHONE_DIRECTORY" & _
" WHERE EXTENSION_NO LIKE [something1] " & _
" ORDER BY LAST_NAME, EXTENSION_No ; "

Public Sub Text1_change()
CQ![something1] = "*" & Text1.Text & "*"
.......
.......(more coding)

1. by changing the statement CQ![something1] = Text1.Text TO CQ![something1] = "*" & Text1.Text & "*" everything works