Report Security Button

[Guest]

How do I create a command for a button that if someone is logged on they can
only view this report if they are authorized to or they have to log in to the
report in order to view it. Example:

If "Brooks" or "Rotunno" is logged in they can only view the "rptsalesreport"

Is there an expression I can write to assign only certain people to view
this particular report?

I have the securities in place but even when I assign permission to
different reports other folks can still view them.

Hopefully that made sense? So far this message board forum has been a life
savor for me!

 

[TC]

Presumeably there is already a button which runs that report. The code
for it, would look something like this:

private sub cmdBLAH_Click (cancel as integer)
docmd.openreport ....
end sub

You just need to add the lines in ALL CAPS:

private sub cmdBLAH_Click (cancel as integer)
SELECT CASE CURRENTUSER()
CASE "Brooks", "Rotunno"
docmd.openreport ....
CASE ELSE
MSGBOX "Sorry, you are not authorized to run this report"
END SELECT
end sub

HTH,
TC

 

[Guest]

Thank YOU SO MUCH!!!!!!!!! It worked!!!!

Deb.

 

[TC]

Well done

TC