Bring form to front

  • Thread starter Thread starter Van T. Dinh
  • Start date Start date
V

Van T. Dinh

How do you open the Password form? (Assuming it is a Form
you created an not an InputBox).

Van T. Dinh
MVP (Access)
 
If I understand correctly, from the Switchboard, you open the frmPassword.
The use can then enter the password and click a CommandButton on the
frmPassword to enter the frmProtected after your code confirms the correct
password.

In that case, try something like (after confirming the password) in the
CommandButton_Click Event

DoCmd.OpenForm "frmProtected"
DoEvents
Forms!frmProtected.SetFocus
DoCmd.Close acForm, Me.Name, acSaveNo

If the above doesn't work, try replacing the SetFocus statement with:

DoCmd.SelectObject acForm, "frmProtected", False
 
Back
Top