Filter a continuous form

[CanWest]

I am trying to filter a continuous form to show only records between two dates. On the form I have a field call ScheduledStartDate and two text boxes one call txtStartDate and the other named txtEndDate. I allso have a command button named cmdApplyDateFilter with the following code.

Private Sub cmdApplyDateFilter_Click()

    Me.Filter = Me.ScheduledStartDate = " Between #" & Me.txtStartDate & "# and #" & Me.txtEndDate & "# "
    Me.FilterOn = True

End Sub

It 'appears' to work but returns no records when i enter a date in each of the ext boxes. The dates are in a valid date format similar to 0810/2011 and 08/31/2011

I know for a fact that there are records that fall into this date range. Any Ideas would be greatly appreciated.

 

[Taruz]

Hi..

with between operator, equal operator should not be used.. also, Try giving the full path of the text boxes ..:

Me.Filter = "[ScheduledStartDate] Between [Forms]![form_name]![txtStartDate] And [Forms]![form_name]![txtEndDate]"
Me.FilterOn = True

it's another way..:

docmd.applyfilter, "[ScheduledStartDate] Between [Forms]![form_name]![txtStartDate] And [Forms]![form_name]![txtEndDate]"

I hope that helps..

 

[CanWest]

Hi..

with between operator, equal operator should not be used.. also, Try giving the full path of the text boxes ..:

Me.Filter = "[ScheduledStartDate] Between [Forms]![form_name]![txtStartDate] And [Forms]![form_name]![txtEndDate]"
Me.FilterOn = True

I hope that helps..

That worked perfectly. Thank you, Thank you, Thank you. I have been ripping what little hair I have left out.