Missing operator 1

[andzejek]

runtime error '3075':
Syntax error (missing operator) in query....

Why I'm getting this eror message when trying to open form:

DoCmd.OpenForm "customer_old", , , "where [CUST_ID] =Forms![FRM_SRCH]![lstSearch]![Value]"

where lstSearch is a listbox

 

[PHV]

What about this ?
DoCmd.OpenForm "customer_old", , , "CUST_ID=Forms!FRM_SRCH!lstSearch"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[andzejek]

this same error message

 

[dhookom]

Some of this depends on the data type of CUST_ID. If it is numeric:

 Dim strWhere as String
 strWhere = "[CUST_ID] = " & Forms![FRM_SRCH]![lstSearch]
 DoCmd.OpenForm "customer_old", , , strWhere

If it is text

 Dim strWhere as String
 strWhere = "[CUST_ID] = """ & Forms![FRM_SRCH]![lstSearch] & """"
 DoCmd.OpenForm "customer_old", , , strWhere

If the code is running in the form "FRM_SRCH" then

 Dim strWhere as String
 strWhere = "[CUST_ID] = """ & Me![lstSearch] & """"
 DoCmd.OpenForm "customer_old", , , strWhere

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[andzejek]

Thank you! it is working now!