Can someone please tell me what's wrong with my string:
DoCmd.OpenForm "frmAttendanceMain2", , , "[CourseCode] = '" & Me.CC & "'" AND [CourseDate] = '" & Me.CD & "'"
Thanks,
Al
Can someone please tell me what's wrong with my string:
DoCmd.OpenForm "frmAttendanceMain2", , , "[CourseCode] = '" & Me.CC & "'" AND [CourseDate] = '" & Me.CD & "'"
Thanks,
Al
Your CourseDate has to be couched in # signs - like this:
And [Coursedate] = #" & Me.CD & "#"
I hope this helps.
THANKS!!!
Al
You're Welcome! I'm happy I could help.