Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
VBA Filter problem
- Thread starter Moss100
- Start date
What makes you think it's not working?
Have you tried just Date() in place of Int(Now())?
Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
Have you tried just Date() in place of Int(Now())?
Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
I my opinion, the safest way to do it is:
So you can actually SEE your filter before you apply it.
BTW, you do not need [] around your field's name if you do not use spaces or reserved words in your fields' names.
---- Andy
"Hmm...they have the internet on computers now"--Homer Simpson
Code:
Dim strFilter As String
...
strFilter = "Ten_Lease_Start_Date < " & DateAdd("yyyy", -6, Date())
Debug.Print strFilter
Me.Form.Filter = strFilterSo you can actually SEE your filter before you apply it.
BTW, you do not need [] around your field's name if you do not use spaces or reserved words in your fields' names.
---- Andy
"Hmm...they have the internet on computers now"--Homer Simpson
- Status