Go to the subform and open it in design view. Find the onclick event. To the
right will be a little square - click on it and pick code builder. Type the
following starting with where the cursor is:
Dim stpassword as string
stpassword = inputbox ("enter your password")
If stpassword = "your password" then
docmd.openform "your form name",,, acnormal
else: Msgbox "you entered the wrong password", vbokonly
end if
Go to the subform and open it in design view. Find the onclick event. To the
right will be a little square - click on it and pick code builder. Type the
following starting with where the cursor is:
Dim stpassword as string
stpassword = inputbox ("enter your password")
If stpassword = "your password" then
docmd.openform "your form name",,, acnormal
else: Msgbox "you entered the wrong password", vbokonly
end if
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.