Need help with Data Mismatch on a date field 1

[dlsd619]

Can somebody help me with the following string. It's a date field and I have never done this with a date field. Not sure how to use the # and etc...

I currently have it set for a text field, but that is just not working.

Thank you:


rs.FindFirst "[ActivityDate] = '" & Me![txtActivityDate] & "'"

 

[fneily]

Try
rs.FindFirst "[ActivityDate] = #" & Me![txtActivitydate] & "#

 

[dlsd619]

Thank you...I couldn't figure it out. I just couldn't let go of those single quotes..