title: Selecting records in MS Access form based on combo box contents
body: <p>I have an access database with two tables, one for users and the other for user permissions.</p>
  
  <p>The users table has a list of user names with a unique ID:</p>
  
  <pre><code>ID | Name
  1  | Joe Bloggs
  2  | Steve Smith
  3  | A Another
  </code></pre>
  
  <p>and the permissions table has a list of user IDs and the zones theyre allowed to access:</p>
  
  <pre><code>ID | Zone1 | Zone 2
  1  | X     |
  2  |       | X
  3  | X     | X
  </code></pre>
  
  <p>I have created a form for updating the user's permissions based on the permissions table which all works fine stepping forward and back manually, and on this form I have a combo box that lists all the users from the first table.</p>
  
  <p>My question is, how do I make this navigate to the record in the permissions table? I know i need to put some code in the "after update" field for the combo box, and managed to get it to work when the combo box was displaying the User.ID field but not User.Name. I have also set a relationship between the two user ID fields but this hasnt worked either.</p>
  
  <p>In Summary, I want to select "A Another" from the username drop down box, this has an ID of 3 in the users table, and then navigate to record ID 3 from the permissions table.</p>
  
  <p>Thanks in advance</p>