syntax 3077 error

  • Thread starter Thread starter Janine
  • Start date Start date
J

Janine

Guest
HELP!!!

I know very little about Access97 BUT with the help of wizards, I've been able to create a database.

In a form that I've placed on a switchboard, I've added a combo box to provide a dropdown list so the user can select the desired name/record.

It's working pretty well except for one record that displays this message when I select it: "Run Time error '3077' Syntax error-missing operator in expression."

In the module/form view, the line that's highlighted reads:
Me.RecordsetClone.FindFirst " = '" & Me! [combo8] '" Could some... it seems very much like a "mountain" Janine
 
You almost got it! Your line of code should be:

Me.RecordsetClone.FindFirst " = '" & Me! [combo8] & "'" (I adde... has been edited by DML (edited 07-12-2000).]
 

Users who are viewing this thread

Back
Top Bottom