[AccessD] A2003: Filter Property

Darren,

The Form's filter property is a string but if you're trying to apply the
filter to a date field, make sure you include the hash marks around the
date string so the datasource can compare it properly.

Charlotte Foust


-----Original Message-----
From: Darren DICK [mailto:d.dick at uws.edu.au] 
Sent: Thursday, November 11, 2004 4:32 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] A2003: Filter Property


Hello all
The help wasn't very helpful
I want to apply a filter to a form using criteria from other controls
like Me.Filter = "DateOfBilling = " & Me.txtStartDate Me.FilterOn = true
 
 
It doesn't seem to work (IE It returns no results) 
But I have about 20 records where about 6 of those records 
have the same DateOfBilling date as I am typing into txtStartDate field
 
So why don't I see those 6 returned from the 20??
 
Many thanks 
 
Darren
 
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com