[RESOLVED] Correct my SQL stt (wait, trying to see in FAQs)

[MintFlavor]

Can anyone help me correct syntax error(s) in the following code:

MyRSDetails.Open "SELECT tblClients.ClientCode, tblClients.* FROM tblClients" & _
"WHERE tblClients.ClientCode = '" & strClientID & "';", conn, adOpenKeyset, adLockOptimistic

Runtime error : Syntax error in FROM clause.

Thank u

[amrita]

MyRSDetails.Open "SELECT * FROM tblClients" & _
" WHERE tblClients.ClientCode = '" & strClientID & "'", conn, adOpenKeyset, adLockOptimistic

[Ecniv]

Yeah - you need a space after the table name.
Best thing is to put the sql statement into a string variable then you can debug.print it (or breakpoint n check it).

[salvelinus]

You need a space between tblClients and WHERE.
The semicolon is ok but not needed.
If ClientCode is a numeric field, you'll need to use a numeric variable, not a string.