Can i Filter Date by using Check Box

champs · #1 06-13-2009, 06:38 AM

Hello everybody,

I have a pop-up multiple filter form where I like to add a check box, which would filter the date older than today. How do I configure the check box?

Thank you in advance.

Kafrin · #2 07-14-2009, 06:41 AM

In the AfterUpdate event of the checkbox you need code something like:

If Me!ChkBx Then

Me.Filter = "DateField < Date()"
Me.FilterOn = True

Else

Me.Filter = ""
Me.FilterOn = False

End If

Welcome to the Excel Forum

Forum Statistics