title: Microsoft Access - Show name of logged in user from UserID
body: <p>I have an Access database I'm working on which has a simple login system consisting of a drop down (combo) menu to select the username, a password field and a users table.</p>
  
  <p>Inside the users table, I'm storing the username, password and the first name of all the users. I've managed to get my login form working, but I'd like the user's first name to be displayed in a text box on the next form.</p>
  
  <p>I've managed to get the user's ID number, and display it in a text box, but I haven't been able to get the user's first name.</p>
  
  <p>Does anyone know of a simple way to display the user's first name in a text box, keeping in mind I'll have several forms where I wish to display the user's first name?</p>
  
  <p>Thanks</p>