Greetings
this is supposed t be simple but it is driving me crazy
i searched all over for an answer until i gave up
i have a form with a search box set to date
and afterupdate i run this code
Private Sub Plan_Date_Search_AfterUpdate()
Me.Filter = " [PLANS RCVD DATE] = # " & [Plan_Date_Search] & "#"
Me.FilterOn = True
End Sub
and it does not filter the date i am looking for ... all the records are filtered out !!!
what am i doing wrong ?
thanks in advance