secure record

[Guest]

I have a checkbox on my form that I want to allow the supervisor to choose
whether or not to hide an individual record. Is this possible?

 

[Rick B]

Sure. In the form that your users use, just include criteria in the query
to pull only records where that checkbox is not selected.

If you want to get really fancy, then you could look at who is logged on and
hide the records if there is not a supervisor logged on, or show all records
if there is a supervisor logged on.

Without knowing more about your current security (how do you know it is a
supervisor) or where you want to hide them (form, report, query?) it would
be hard to give you a more detailed answer.

 

[Stefan Hoffmann]

hi Leslie,

I have a checkbox on my form that I want to allow the supervisor to choose
whether or not to hide an individual record. Is this possible?

Yes, if you use a field to store the visibility.

Add a boolean field IsVisible to your table and use

SELECT * FROM

WHERE [IsVisible]

as data source for your normal users.


mfG
--> stefan <--

 

[Guest]

thank you both, I created two forms, one with secure record based on query
and the other with unsecured records and depending on your login, that's what
form I am displaying...again thanks alot