Limit Number of Records that can be Accessed in a Form (1 Viewer)

[anski]

I have a database that has transactions since year 2009. I want the users to only be able to view and edit transactions that were entered in the last 6 days. I was initially able to do this by putting a filter in the Property Sheet section of the form and choosing Yes for Filter on Load.

However, a user was able to discover that by clicking on Clear All Filters, the filter I set was also cleared, thus making them see all the transactions beginning year 2009.

Is there any other way for me to achieve this? Thanks.

 

[plog]

Your form's Record Source is either a table or a query. If it's a table, make a query based on that table and apply criteria to it to show just the last 6 days of data (>=(Date - 6)), then make your form's Record Source that query. If its already a query, apply that criteria to it.

Then hope your user's don't realize they can hit F11 to open up all the tables and see all the data no matter what.