Run Time Error 3077 Findfirst

Question

"Run-time error 3077.  Syntax error in expression."

I received this message while trying to perform a findfirst in VBA. 

However, I don't receive this error when the field name is a single word.  When I changed the field name from "Email Address" to "Email_Address" the error went away.  Has any one else had this problem?

Thanks.

Answer 1

Ummm...

You can see your code. Nobody here can!

If you (unwisely, IMO) use blanks in fieldnames you must enclose the fieldname in square brackets: [Email Address] for example. But please post your code so we can see if that's the issue or it's something else.