title: How to direct users to their own designed menus
body: <p>I have created a 3 level user access database in MS Access 2007 and what I would like to happen is when each user logs in they are directed straight to their own purpose build menus i.e. Admin Menu, Developer Menu and User Menu. </p>
  
  <p>At the moment whichever user logs in gets directed straight to the main menu and if the user logged in only has the access level of a user he can still access admin and developer tables/forms etc. </p>
  
  <p>Below is the VB code I have inputted for when the user enters their password and logs in.  What additional code can I put in so it directs each specific user to their menu?</p>
  
  <pre><code>Private Sub txtPassword_AfterUpdate()
  
  'Check that EE is selected
  If IsNull(Me.cboUser) Then
      MsgBox "You need to select a user!", vbCritical
      Me.cboUser.SetFocus
  Else
      'Check for correct password
      If Me.txtPassword = Me.cboUser.Column(2) Then
          'Check if password needs to be reset
          If Me.cboUser.Column(3) = True Then
              DoCmd.OpenForm "frmPasswordChange", , , "[UserID] = " &amp; Me.cboUser
          End If
          DoCmd.OpenForm "frmMainMenu"
          Me.Visible = False
      Else
          MsgBox "Password does not match, please re-enter!", vboOkOnly
          Me.txtPassword = Null
          Me.txtPassword.SetFocus
      End If
  End If
  End Sub
  </code></pre>