[cade]

this should be easy please help
StrSql = "SELECT * FROM [" & Screen & "] WHERE (CPN="&(COORDID)&") AND (CNUM="&(CNUMQS)&")

Thanks
Cade

[Minakshi]

Hi,
Pls try this:

StrSql = "SELECT * FROM [" & Screen & "] WHERE (CPN="&(COORDID)&") AND (CNUM="&(CNUMQS)

bec

"SELECT * FROM [" ----- First string
& Screen & -------variable
"] WHERE (CPN=" -------Second string
&(COORDID)& -------variable
") AND (CNUM=" -------Third string
&(CNUMQS) ------last variable ---- (imp *****not a string)

[Tom Tom]

SELECT * is actually bad practice in real world programming. Best practice is to specify explicity the columns to select.

any way use this if COORDID and CNUMQS are numerical values

StrSql = "SELECT * FROM " & Screen & " WHERE ((CPN="& COORDID &") AND (CNUM="& CNUMQS))

else

StrSql = "SELECT * FROM " & Screen & " WHERE ((CPN= '"& COORDID &"') AND (CNUM='"& CNUMQS&"'"))