Feb 23 2005, 05:38 AM
I'm probably being really stupid here, but I'm trying to filter records on a form. In the 'Filter' property in the Data tab of the form's properties, I entered HireDate=Date(), but it still returns all the records anyway. Any ideas?
Feb 23 2005, 05:49 AM
Set the filterOn property to yes
Feb 23 2005, 05:52 AM
Sorry, I'm being dense. Where's the filterOn property? I have the 'Allow Filters' property set to yes.
Feb 23 2005, 07:30 AM
That's the same property Jim suggested...
Feb 23 2005, 07:42 AM
Oops, sorry about that, I miss-represented the name
Feb 23 2005, 07:48 AM
Not much of a difference since FilterOn is used for reports
Feb 24 2005, 12:16 PM
Ok, the form is set to allow filters, but e.g. tblCustomer.Forename = 'Joe' won't work and neither will (tblCustomer.Forename = 'Joe'), nor using  around the different parts and replacing the . with a !. Any ideas?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here