[AccessD] A2003: Filter Property

Hi Darren

The only foolproof way is to force US formatting of date strings:

  Me.Filter = "DateOfBilling = " & _
    Format(Me.txtStartDate, "\# mm\/dd\/yyyy \#")

/gustav


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