How can I filter out a subset of records through a checkbox

T

tracy.cooperjr

I am working with access 2000. I am trying to make a checkbox that will
be able to be clicked in an administrator form and make it so a
specific record will not be able to be seen in the general users form.
The problem I am having is that both forms are based off of the same
query because I thought I could use the "filter" setting within the
form to filter out all records that are checked. Unfortunately
everytime I try to use the filter setting nothing happens and all of
the records are shown. Am I using the setting incorrectly? Is there
something else I need to do?
 
B

Bill

You might want to post the code segment that you are
using to set the filter. If your database is configured in
such a way that "restricted" records are clearly identifiable,
there's no reason why they can't be filtered out when a
non-administrator is the current user. And, of course, the
latter also has to be clearly identified.

Bill
 
Top