Formating Date Code to open Report 1

[lars7]

Hi Guys,
Could anyone help with this Code problem. I want a Report to open with the following:

DoCmd.OpenReport "ReportSignUpSheet", acViewPreview, "", "contact='" & List1 & "and AssDate=#" & Format(Me!List2, "mmm-yy") & "# "

but I'm getting a "Syntax error in string in query expresssion" message.

This is the format of the field Assdate "mmm-yy" giving me this date "Oct-06".

Thanks in advance.

 

[WildHare]

You need an extra single quote there after the

& List1 & " ' ... part

--------------------------------------
"For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled." - Richard P. Feynman

 

[lars7]

Thanks WildHare,
I missed that.