Password protect a form

[recon2011]

Is there a way to set a password on a form? I have a form that opens via a macro set to a command button. I need the form to be available on a banner but restrict its contents to those with a passwrod. This obviously is in a multiple user environment. I am not a novice but I am not a VB programmer either. Use of everything but codes I am competent with. Thanks in advance.

[June7]

Is this one universal password or each user has own? User enters password into textbox or popup InputBox. If entry matches value in table or hardcoded in procedure, then proceed to open form, else MsgBox saying invalid password.

[recon2011]

One universal password to open a form.

[June7]

I don't use macros so in VBA, something like:

If Me.txtPassword = "passwordstring" Then
DoCmd.OpenForm "formname"
Else
MsgBox "Incorrect password. Try again."
End If

[recon2011]

Thanks but I am looking for a way to actually create the ability to use a password in something (form, macro, command, etc) that will open the form. Using the string you provided only works if it is attached to something that asks for a password to begin with.

[June7]

A password is an input parameter, it has to come from somewhere, so don't understand what you are wanting.

I offered VBA code but did not specify what event to put it in. Could be the AfterUpdate of a textbox or a command button Click.

[recon2011]

Sorry for the delay.

Simply put: I have a command button on a form that opens another form. However, I want that second form to be password protected. The button already exists as does the second form. Just need to password protect it. How?

[ansentry]

You wrote:

I have a command button on a form that opens another form.

I want that second form to be password protected

Are these the same form?

If they are then have a look at the attached sample. The password is "password"

Have a look at the code behind the command button to see how it works.

If my assumption is wrong post back.

[recon2011]

John A,

Thank you. That is exactly what I needed. I appreciate your taking the time to help me. I will mark this solved. Can you also take a look at the thread for "Field Value"? I am trying to do some conditional formatting, I think. Thanks again.

Marty C

[dichotomous]

John A. Your code worked for my Database. I now have a password as a gateway between the main database and the HR modal Dialogue. Yipee. Spent a whole darned day looking for this.

[ansentry]

John A. Your code worked for my Database. I now have a password as a gateway between the main database and the HR modal Dialogue. Yipee. Spent a whole darned day looking for this.

Glad to help