FindFirst vs Seek

abbyanu · Apr 22, 2002

Hi

I have a line

Code:

.FindFirst (&quot;ProductNumber ='&quot; & Prodno)

that is generating an error:

Code:

Run-time erroe '3077'
Syntax error (missing operator) in expression.

I've tried all variations, but in vain. Any idea what's causing the problem? It's also slow. I've also read somewhere in this forum that

Code:

seek

is faster than

Code:

FindFirst

. Can this be used instead, in my case? How?

Thanks for your time.

AbbyAnu.

RobertT687 · Apr 23, 2002

If this is the exact line, you have a missing single quote in the expression.
Try:
FindFirst ("ProductNumber ='" & Prodno & "'&quot

.

abbyanu · Apr 23, 2002

Thanks, Robert.