Syntax error (missing operator) in query expression message

[Guest]

Hi,

Using the command button wizard I created a button to open another form to
only display records related to the record open on the main form. For some
reason though, I only get the following error message appear when I have one
specific record on display on the main form. For all other records on the
main form, the other form opens okay displaying the filtered records:

Syntax error (missing operator) in query expression
‘[GrantPotMemberBelongsTo] = ‘Young People’s Programme’

Help will be most appreciated as I still haven’t found out the reason why.

Thank you

Ammo

 

[Guest]

You can't have a string bounded by single quotes with a single quote within it.
Put double quotes on the outside.
"Young People’s Programme"

Dorian