How to set password to open form

[naveen prasad]

Hi all,

I have created a form , in that command button is created when clicked it
will open another form.

but i need when button is clicked a input box should appear requiring
password.

when password entered then only that form should open.

pls help me these 2 things.

1. when password is entered in inputbox , i want to display message box with
entered password ... how can i do it.

 

[Gina Whipp]

Naveen,

Something like...

If Me.txtPassword = "ugh" Then
DoCmd.OpenForm "YourForm"
Else
MsgBox "You do not have permission to view this report!"
DoCmd.Close
End If


--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi all,

I have created a form , in that command button is created when clicked it
will open another form.

but i need when button is clicked a input box should appear requiring
password.

when password entered then only that form should open.

pls help me these 2 things.

1. when password is entered in inputbox , i want to display message box with
entered password ... how can i do it.