Cynthia_D,
Probably the easiest thing to do would be do put it in the On_Click event that opens up your secondary switch board. The way it is written here you would need to put it behind each button that opens up a sub switchboard. It may be a little redundant but it will give you the flexibility of using a different password for each switchboard in your project.
Then all you have to do is modify the YourPassWord and then put the Open secondary switchboard command you are using now where I put the " ' Open specific form here".
Also to make it a little more user friendly you could put a message box between the Else and Exit Sub like this:
Else
MsgBox "The Password you entered is incorrect!" & vbCrLf & _
"Please try another", vbCritical, "Password Error"
Exit Sub
[This message has been edited by Talismanic (edited 02-08-2001).]