[AccessD] A2003: Filter Property

If the delimiters are the problem as Stuart suggests, you should be able to
use the following:

Me.Filter = "DateOfBilling = #" & Me.txtStartDate & "#)"

I know that the Filter property can be a real pia, but I don't remember why
off the top of my head. Don't forget to enable it -- something like

Me.Filter.On = True

???? Really not sure about that last one -- but you need to make sure the
form knows to actually use the filter. 

Susan H. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Thursday, November 11, 2004 7:48 PM
To: Access Developers discussion and problemsolving
Subject: Re: [AccessD] A2003: Filter Property

On 12 Nov 2004 at 11:32, Darren DICK wrote:

> 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??
>  

Good old Internationalisation and date display formats strikes again?

Try
Me.Filter = "DateOfBilling = DateValue('" & Me.txtStartDate & "')"


-- 
Stuart


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com