Hi

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?

Thanks

Joe

Set the filterOn property to yes

hth
jim

Sorry, I'm being dense. Where's the filterOn property? I have the 'Allow Filters' property set to yes.

That's the same property Jim suggested...
Try:
(YourRecordSource.Hiredate=Date())

HTH

Oops, sorry about that, I miss-represented the name .
Cheers Charles
Jim

Not much of a difference since FilterOn is used for reports

o!

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?