Filter Not working

[Sadukar]

Can someone tell why this is not working?

On a form I have a subform, 2 text boxes and a button.
One of the fields in the subform is a date field. I want to filter between 2 dates. this is the code I used for the button.

Me.subform.Form.Filter = "[Date] between #" & Text36 & "# and #" & Text40 & "#"
Me.subform.Form.FilterOn = True

This code causes the subform to show no data.

What am I doing Wrong?

Thanks
S

 

[MisterC]

You could put the date filter criteria in the form's header instead of using a form/subform setup.

 

[Sadukar]

no
I want form/subform set-up

thanks for suggestion