Filter using a textbox date value on form 1

[Moss100]

Hello I am struggling with some code to get my form filer working.

Bacically I have a continuous form and I am filtering the records on an after upadte event. All is working OK with the code below:

Me.Form.Filter = "[Cand_Joint_Name_Long] LIKE '*" & Me.txt_Find_Name & "*'"
Me.Form.FilterOn = True

I would like to modify this filter so it only displays records which have an added date on or equal to the value in a textbox on the form called: txt_Filter_Date_Added

Help much appreciated.

Regards

Mark
















Me.Form.Filter = "[Cand_Joint_Name_Long] LIKE '*" & Me.txt_Find_Name & "*'

 

[Andrzejek]

Did you try:

Me.Form.Filter = "[Cand_Joint_Name_Long] LIKE '*" & Me.txt_Find_Name & "*'[highlight #FCE94F] AND DateField = #" & txt_Filter_Date_Added & "#"[/highlight]
Me.Form.FilterOn = True

---- Andy

There is a great need for a sarcasm font.

 

[Moss100]

Magic - thank you