H
hughess7
Hi, I have two unbound fields on a form (startdate and enddate) and a filter
button. I am having problems getting the code to work though... I want all
records to be displayed that are between the two dates, to include the actual
start and end dates too. My regional settings are UK, without the format$
code I received type mismatch error. Please could someone tell me where I am
going wrong...
Me.Filter = "[ReviewDate] >= " & Format$(StartDate, "mm\/dd\/yyyy") And
[ReviewDate] <= " & Format$(EndDate, "mm\/dd\/yyyy")"
Me.FilterOn = True
Thanks in advance for any help.
Sue
button. I am having problems getting the code to work though... I want all
records to be displayed that are between the two dates, to include the actual
start and end dates too. My regional settings are UK, without the format$
code I received type mismatch error. Please could someone tell me where I am
going wrong...
Me.Filter = "[ReviewDate] >= " & Format$(StartDate, "mm\/dd\/yyyy") And
[ReviewDate] <= " & Format$(EndDate, "mm\/dd\/yyyy")"
Me.FilterOn = True
Thanks in advance for any help.
Sue