Syntax error on where arguments

[svigneault]

I'M trying to filter data to verify if a date for a particular school run as been treated.
Here is my code:

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

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

I must miss something here...
Sorry for my english, I'm a french canadian....

 

[Trevor G]

Try changing the date into the Amercian format. So this and are you missing a square bracket ]

#28/05/12#

would become this

#05/28/12#