Delete Button

[Stockwell43]

Hello,

On my form I would like to put a delete button but ONLY the managers can
have access to it. If a record needs to be deleted, I would for the manager
to just click the button and the record will be deleted of course with a
message box asking "Are you sure you want to delete this record". But I only
want the managers to be able to use the button and not the users so maybe
some type of password that will either Show, unlock or enable the button. Is
this possible?

Thanks!!!

 

[ridders]

Hi


I suggest you make the Delete button invisible unless the logged on user is
a Manager.

Create a Boolean (Yes/No) field called Manager & identify which users are
Managers. Then add code to make the Delete button (cmdDelete) visible if
Manager = Yes

If Manager = Yes Then cmdDelete.Visible = True