I know the answer to this must be quite straightforward but after searching for hours I'm going nuts and would really appreciate some help.
I'm trying to open a form for a specific department and capture date. I can do either in a single statement but when I put them together I'm getting a mismatch error
What am I doing wrong please, Thanks in advance
Ian
'DoCmd.OpenForm "form4", , , "[department]='" & Me![Department] & "'"
DoCmd.OpenForm "form4", , , "[capdate]=#" & Me.[capdate] & "#"
'DoCmd.OpenForm "form4", , , "[department]='" & Me![Department] & "'" And "[capdate]=#" & Me.[capdate] & "#"