[AccessD] A2003: Filter Property

Oops worked it out
It's

Me.Filter = "DateOfBilling >= DateValue('" & Me.txtStartDate & "')" _
 & "and DateOfBilling <= DateValue('" & Me.txtEndDate & "')"

Many thanks y'all

See ya

Darren
Stuart --- you da man !!!!!!!!!!!!1


 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Friday, 12 November 2004 11:48 AM
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