Password to open certain report

[ake]

Please help me to add a password on opening a specific report.
I want to add a command button that once clicked would ask for a password,
when the password is correct it would open a certain report but if the
password is wrong a message box will open that advise the user that he cannot
open the report.

I am trying to do this with VBA but i am having a hard time. Please tell me
what to do.

 

[ake]

Hi Chris! Thanks for your help. I don't know why but there must be something
we've missed in there, it didn't work. The report opens but it doesn't ask
for a password.