Securing a CMB

[Ivan Grozney]

I was wondering if I can put a password on a command
button. I pretty well Locked down the database but I have
a report that I would like to allow one or two users to
edit. I created a Command Button to open it in edit mode
but I would like to secure it if possible.

tia Ivan

 

[John Vinson]

I was wondering if I can put a password on a command
button. I pretty well Locked down the database but I have
a report that I would like to allow one or two users to
edit. I created a Command Button to open it in edit mode
but I would like to secure it if possible.

tia Ivan

Just put code in the button's Click event to prompt for a password
(using InputBox perhaps) and exit the click event if they don't use
the right password.