filter form with mulitple conditions

[kes]

Hi,

I want to open a filter form with mulitple conditions.one of them is a date condition.
I'm using access 2013 and the code below:

DoCmd.OpenForm "Edit_Mission", acNormal, , "[Report_Date]= " & Me.Date & " And [Supporter_Name]='" & Me.Supporter & "'"

it's opens the form but with no data. I also tried the # and it's still didn't work.

 

[pbaldy]

It would need the #. Make sure you aren't running into this:

http://allenbrowne.com/ser-36.html#Format