MsgBox popup that needs user imput

[ksgirl2]

hello,

I need to create a message box that asks the user for a text string before a form is opened. This text string will have to match another one (password) before the form will open. If the wrong password is entered i need a message box to pop up and say "wrong password" and have an ok button on it to close it. What is the code to create this on an event procedure On Load?

Thanks in Advance!

Marie

 

[Rick39]

Take a look at the InputBox funtion

 

[ksgirl2]

I'm still not understanding how to use the input box function. Thanks for the tip. Any other suggestions?

m

 

[compucop]

try this
dim strinput as string

strinput = inputbox ("please enter password&quot

if strinput = (password) then
docmd.openform "nameofyourform",acnormal
else
msgbox "wrong password, try again"
end if
you'll have to substitute your password into the (password) area, probably best to use a variable. Im sure you will get the idea. Post back if you need further help. Later.

 

[ksgirl2]

WORKS LIKE A CHARM! Thanks! That's just what i was looking for!

marie