open new form with date from unbound field in anthoer form

[mlrucci]

I am attempting to enter a date(dtDate) on frmHistoryDate and open another form with all entries and data on antoher form (frmLogActivityReview). I used the vba code:
DoCmd.OpenForm "frmLogActivityReview", acNormal, , "[DateCase] ='" & Me.dtDate

It opens the form, but does not show data (form is blank). I know it is something simple I am missing. Can anyone help?

[ranman256]

your filter is broken...it only has 1 quote. Fix:

DoCmd.OpenForm "frmLogActivityReview", acNormal, , "[DateCase] ='" & Me.dtDate & "'"

[mlrucci]

When I run that code, I get a run-time error 3464 for data type mismatch. I checked both fields and they are both short date. any ideas?

[mlrucci]

I found the problem, first, need to change the single quote (') in the command to #. I also removed the brakets ([]).
OLD:

DoCmd.OpenForm "frmLogActivityReview", acNormal, , "[DateCase] ='" & Me.dtDate & "'"

NEW: DoCmd.OpenForm "frmLogActivityReview", , , "DateCase = #" & Me.dtDate & "#"

Thank you for your help!