Simple filter on form

[BrockLanders]

I'm trying to filter a form whose source is a table. I'm filtering on a date field, but it's not working. I'm not using code to do the filtering, just the Form properities window. I'm trying to only return those records where the date is 12/7/05. In the option for Filter, I'm typing,
(([2006 Sched].[Date]=#12/7/05#))
but all records are being returned and no error message. It's as if nothing is even typed into the Filter property.

 

[PHV]

A filter should be applied.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886