Filter Help

[dgaller]

I have a form [Local Delivery History] with a subform [Local Delivery subform] on the main form I have a text an unbound text field [Text20] formated for a date. I want to be able to do an after update filter using this form. I tried

Me.[Local Delivery Subform].Form.Filter = "([Ready Date] ="" & Me!Text20 & "")"
Me.[Local Delivery Subform].Form.FilterOn = True

and get a error that I canceled the operation?

What am I doing wrong. I can do it with text or numbers the dates seem to be causing an issue?

 

[MStef]

Try this:
...........="[Ready Date]=#" & Me.Text20 & "#"

 

[dgaller]

Thank you that worked!