Use a checkbox to control visibility of records?

  • Thread starter Thread starter Maury Markowitz
  • Start date Start date
M

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)?
 
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)?
Click to expand...

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