Full Version: Filter property
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
josno
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
jsitraining
Set the filterOn property to yes
th
jim
josno
Sorry, I'm being dense. Where's the filterOn property? I have the 'Allow Filters' property set to yes.
Chaga
That's the same property Jim suggested...
Try:
(YourRecordSource.Hiredate=Date())

HTH
jsitraining
Oops, sorry about that, I miss-represented the name blush.gif.
Cheers Charles frown.gif
Jim
Chaga
Not much of a difference since FilterOn is used for reports wink.gif
o!
josno
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.