Run-time error 3077 1

[mca2k4]

Hi,
I keep getting

"Run-time error '3077':

Syntax error (missing operator) in expression.

here is my code:
rst.FindFirst "3Digit Item Number = " & LBx.Column(0)

I never got this problem when "3Digit Item Number" used to simply be "MSID" instead. Anyone know how to fix this?

Thanks.

 

[PHV]

rst.FindFirst "[3Digit Item Number] = " & LBx.Column(0)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mca2k4]

Thanks for your response PHV, but it's still giving me the same error. Any other ideas?

Thanks.

 

[PHV]

Is "3Digit Item Number" defined as numeric ?
Is LBx populated and selected ?
You may try this:
rst.FindFirst "[3Digit Item Number]=" & Nz(LBx.Column(0), 0)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mca2k4]

3digititemnumber" is defined as Text

LBx is populated and selected

 

[PHV]

As Text !
rst.FindFirst "[3Digit Item Number]=[tt]'"[/tt] & LBx.Column(0) & [tt]"'"[/tt]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mca2k4]

Still no go w/ "3digititemnumber" as Text; now gives error as "Syntax error".

However, after changing "3digititemnumber" to a Number, the code from your previous code now works!