How to use button to set form filter via query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form set up. On this form, I would like the user to easily select
between two sets of records, each delimited by date ranges. I've created
separate queries to define each of these record sets.

Let's say one of the queries is named "Weekly" and the other is "Yearly".
Each query includes two fields. How do I insert buttons on the form (one
button for each query) that will filter the records visible on the form by
the criteria set in the query?

I've tried different approaches but none work. If you give me code to
insert, please tell me WHERE to put it.

Thank you!
Diane
 
Since I got no responses and still couldn't make it work, I ended up creating
two forms instead of one, and based them on two different queries. It's not
my first choice of how to do this, but it works OK.

If anyone can answer my initial question, I'm still interested.
Thank you.
 
Back
Top