title: Access 2007 - Get VB user login and record for last modified form
body: <p>I created one of microsoft access 2007 database. which is created two forms. 1.employee form. 
  table name "tbl employee": ID,IC NO, Name, Office Branch.
  2.login form. : 
  table name "tble User" : UID,Username,Password,Enable,Fullname.</p>
  
  <p>As usual when i login the username(using combobox) and password(using textbox) the login form is working properly as I'm using VB as shown below:-</p>
  
  <pre><code>Private Sub cbo_User_AfterUpdate()
   Me.txt_Password = Empty
      Me.txt_Password.Enabled = True
      Me.txt_Password.SetFocus
  End Sub
  
  Private Sub cmd_OK_Click()
  'test the stored password is = to the manually entered password
      If Me.cbo_User.Column(2) = Me.txt_Password Then
          DoCmd.OpenForm "fm_employee", acNormal
          DoCmd.Close acForm, "frm_Login"
          DoCmd.Close acForm, "fm_switchboard"
      Else 'wrong match
          MsgBox "Wrong password entered." &amp; _
              vbCrLf &amp; "Please re-enter password.", _
              vbExclamation, "Invalid Password"
          Me.txt_Password.SetFocus 'places the cursor in password control
      End If
      'If User Enters incorrect password 3 times database will shutdown
  
      intLogonAttempts = intLogonAttempts + 1
      If intLogonAttempts &gt; 3 Then
        MsgBox "You do not have access to this database.Please contact admin.", _
                 vbCritical, "Restricted Access!"
          Application.Quit
      End If
  End Sub
  </code></pre>
  
  <p>Now, I need help How to get the fullname or Username from login form and record into the field when after User Client MODIFIED and SAVE every single record from employee form.</p>
  
  <p>Note: login user is more than 1 </p>