Stuart McLachlan
stuart at lexacorp.com.pg
Thu Nov 11 18:48:13 CST 2004
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