DoCmd.OpenForm error

[svigneault]

I have a form to open with arguments. What I want to do is to see if a date has been treated for a particular school run. Here is my code

DoCmd.OpenForm frDates, , , "[DATES_IN] = #" & dateDTjr & "# and [CIRCUIT] = " & CmdCircuit & " , acFormReadOnly, acHidden"

Here is the message from Access:
Syntax error (missing operator) in query expression '[DATES_IN] = #28/05/12# and [CIRCUIT] = C.S.D.M., acFormReadOnly, acHidden'.

I don't know what to do with that.
Please help!!!!

 

[Galaxiom]

"[DATES_IN] =" & Format(dateDTjr,"\#mm\/dd\/yyyy\#") & "and [CIRCUIT] ='" & CmdCircuit & "'"

 

[Galaxiom]

Also please delete the duplicate question.

 

[svigneault]

Thanks Galaxiom
Now the message changed to:
You entered an expression that has no value.

 

[Galaxiom]

Not sure what the problem is but there should not be any quote marks after acHidden as youhave in your original post. What you have there is the last rwo arguments included in the Where Condition string.

DoCmd.OpenForm frDates, , , "[DATES_IN] =" & Format(dateDTjr,"\#mm\/dd\/yyyy\#") & "and [CIRCUIT] ='" & CmdCircuit & "'" , acFormReadOnly, acHidden