I am using VB 6.0 with and Access database.
I am trying to use a global variable in the where clause of my query. I have include my code and you can assume that all variables, etc. are declared and used correctly. I know this for sure, because if I take the where clause out of my query it returns the first record in the PatientInfo table.

I believe my syntax is off or I am just missing some quotes or something??

Note: I have received two different run-time errors with two different values for the global variable *CellValue*
A)The first error is: No value given for one or more required parameters CellValue = NAME
B)The second error is: Syntax error (missing operator) in query expression "[Patient Name]
=A Third" CellValue=A Third (This is just a test value)

strQuery = "select * from PatientInfo"
strQuery = strQuery & " where [Patient Name]="
strQuery = strQuery & CellValue
adoPrimaryRS.Open strQuery, db,adOpenStatic, adLockOptimistic

Any help would be greatly appreciated!!!
Thank you and if I have repeated a similiar question, please refer me to the answer.


------------------
Thanks!