Use a checkbox to control visibility of records?

[Maury Markowitz]

I have a simple continuous form that lists all the entries in a small
table (~35 rows). This list is going to grow over time, and I'd like
to add a switch that limits the view to showing only the "active" rows
- active is any row where there's been associated activity in a year.

The query that's bound to the form already returns a "lastAccessDate".
Is there a way to have a checkbox add a filter on lastAccessDate>= (a
year ago from today)?

 

[Piet Linden]

I have a simple continuous form that lists all the entries in a small
table (~35 rows). This list is going to grow over time, and I'd like
to add a switch that limits the view to showing only the "active" rows
- active is any row where there's been associated activity in a year.

The query that's bound to the form already returns a "lastAccessDate".
Is there a way to have a checkbox add a filter on lastAccessDate>= (a
year ago from today)?

change the rowsource for the subform, then requery the subform.