title: MS Access 2003 - Auto fill form-field based on previous form field.
body: <p>I am currently attempting to design a database that requires a number of users inputting data via forms. </p>
  
  <p>one of these tables is  a 'user' table. Amongst the information in the table is 
  userid (int),
  username (text),
  first name (text),
  last name (text)</p>
  
  <p>In the even that I'm filling out a form and supply the the username in the username field is it possible  if the username already exists to pull the first name and last name from the user table and auto-populate those form fields? If so can you point me in the right direction please?</p>
  
  <p>Directly via access functionality or via vba? If not possible in 2003 is this possible in 2007?</p>