what is the vba code I can use to filter dates on my form

  • Thread starter Thread starter Mike Saifie
  • Start date Start date
M

Mike Saifie

i need a code where I can filter the records by date.
what is the vbc query.
the filed on my Issue table is "opened Date"

Thanks for your help
 
I assume you have two unbound text boxes on your form where the user can
enter the date range (starting date and ending date), and you want to create
a Filter string that returns all records where the [opened Date] field is in
that range?

If so, see:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

The article talks about reports, but you create exactly the same string, and
apply it to the form's Filter instead of opening the report. Instead of the
OpenReport line (the last one), you will have:
Me.Filter = strWhere
Me.FilterOn = True
 
Back
Top