Run-time error '3077':

  • Thread starter Syed Zeeshan Haider
  • Start date
S

Syed Zeeshan Haider

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top