Question Filter form with selected calendar date

[josephbupe]

Hi,

I have a continuous form bound to a query. I want to filter this form with any date inputted into a text box through a pop-up calendar control. The default date in the text box should be Date().

In the query, I set the criteria on Call_Date filled as follows but the form does not requery to return the expected data:

Call_Date:
Criteria: Forms!F_On_Call_Officers!txtEndDate

Your help will be appreciated.

Joseph

 

[Ranman256]

in the date text box, in the AFTERUPDATE event

me.filter = "[Datefld] =#" & txtDate & "#"
me.filterOn = true

 

[josephbupe]

Thanx but the filter is not being applied after update.

Private Sub txtEndDate_AfterUpdate()
Me.Filter = "[Call_Date] =#" & txtEndDate & "#"
Me.FilterOn = True
End Sub