[AccessD] Re: A2003: Filter Property

But,

Me.Filter = "DateOfBilling = CDate(" & Me.txtStartDate & ")"

would, make that should, work with any of them.

You might also want to add me.refresh on the end of the sub.

Robert

At 07:41 AM 11/12/2004 -0600, you wrote:
>Date: Fri, 12 Nov 2004 11:03:25 +1000
>From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
>Subject: RE: [AccessD] A2003: Filter Property
>To: Access Developers discussion and problem    solving
>         <accessd at databaseadvisors.com>
>Message-ID: <4194987D.4043.759244 at lexacorp.com.pg>
>Content-Type: text/plain; charset=US-ASCII
>
>On 11 Nov 2004 at 19:51, Susan Harkins wrote:
>
> > If the delimiters are the problem as Stuart suggests, you should be able to
> > use the following:
> >
> > Me.Filter = "DateOfBilling = #" & Me.txtStartDate & "#)"
> >
>
>Nope, Darren's an Aussie.
>
>Doing it that way gets the month and day reversed if he is using the
>default short date (today is 12/11/04, not 11/12/04 to us) and doesn't work
>at all if he using something like  "12 Nov 04" :-(
>
>--
>Stuart