Example Code? (XP)

Topic

New Reply

Could someone post a short (but expandable) example of the code I would attach to a text box/command button that depending on what password is entered in the box, it directs you to a specific form? I’ve got an If Then attached to the cmd button that looks at the word in the text box, however when I try to add another If Then, it will only go to the default (blank text box) error message.

Reply | Quote

Replies

Why don’t you post the code you’re trying? Then one of us can suggest how to fix it. That would mean more to you than an abstract example.

Reply | Quote

You should be better with a Select case instead of different If Then Else
Select Case Me.txtPasswordTextBox
Case “ABC”
Docmd.OpenForm “ABC”
Case “DEF”
Docmd.OpenForm “DEF”
Case Else
MsgBox “Wrong Password”
Application.Quit
End Select

Reply | Quote