Multiple Fields in Criteria - String

[alsoto]

Can someone please tell me what's wrong with my string:



DoCmd.OpenForm "frmAttendanceMain2", , , "[CourseCode] = '" & Me.CC & "'" AND [CourseDate] = '" & Me.CD & "'"

Thanks,
Al

[Robeen]

Your CourseDate has to be couched in # signs - like this:
And [Coursedate] = #" & Me.CD & "#"

I hope this helps.

[alsoto]

THANKS!!!
Al

[Robeen]

You're Welcome! I'm happy I could help.