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 "[URL] = '" & Me! [combo8] '"

Could someone please tell me what this means and what operator is missing?

I'm sure this is a "molehill" problem, but knowing as little as I do about code, it seems very much like a "mountain"

Janine

You almost got it! Your line of code should be:

Me.RecordsetClone.FindFirst "[URL] = '" & Me! [combo8] & "'"

(I added another ampersand after your combo value and another quote. I know its hard to read like this but after the me![combo8] is: ampersand, double quote, single quote, double quote)


[This message has been edited by DML (edited 07-12-2000).]