Hello Everybody,
In Access 2003, I am using VBA to find a string in a table. Every time I try
to execute following line:

anRST.FindFirst "John Smith"

I get "Run-time error '3077':" which says:

   Syntax error (missing operator) in expression.

Same is true for FindNext, FindLast and FindPrevious.

anRST was defined using following code:

Set anRST = CurrentDb.OpenRecordset("Test", dbOpenDynaset)

Where "Test" is the name of the table.

Any ideas what I am missing?

Thank you,