i have created a wizard that sets up projects that come into my office. i
have required the user to fill in all of the text boxes. this is
accomplished through the code below, which is executed when the Finish Button
is pressed:


For Each MyCtrl In Me.Controls
If TypeName(MyCtrl) = "TextBox" Then
If MyCtrl.Value = "" Then
If MyCtrl.Enabled = True Then
MsgBox "You Did not Enter all of the Required Data "
& MyCtrl.Name
MultiPage1.Value = 0
Exit Sub
End If
End If
End If
Next


i want to include an override option in case all of the text boxes cannot be
filled in. so when the user presses finish, i prompt them that they missed a
text box. then i want to give them an option of entering a password to
disable this feature. how can i write code to prompt them for a password,
and if they enter it correctly, this part of the code is disabled?

Thanks,
STeve