title: How to get an AfterUpdate procedure to update other fields in the same form
body: <p>As of Wednesday morning ...</p>
  
  <p>First, I successfully display and select from my city_table, populating the city_no on the form</p>
  
  <p>I am then attempting to use that value to extract/use the city_nm and state_nm on the same form.</p>
  
  <p>I coded this as the (modified) afterupdate code for city_no.</p>
  
  <pre><code>Private Sub city_no_AfterUpdate()  
  Dim got_city_nm, got_state_nm  
  got_city_nm = DLookup("[city_nm]", "city_table", "[city_no]" = "city_no")  
  got_city_nm = DLookup("city_nm", "city_table", "city_no='" &amp; Me.city_no &amp; "'")  
  city_nm = got_city_nm  
  got_state_nm = DLookup("[state_nm]", "city_table", "[city_no]" = "city_no")  
  got_state_nm = DLookup("state_nm", "city_table", "city_no='" &amp; Me.city_no &amp; "'")  
  state_nm = got_state_nm  
  seat_no = "XXX"  
  End Sub  
  </code></pre>
  
  <p>Still nothing happens including the last statement (assigning "XXX" to seat_no)</p>
  
  <p>So I simplified it to just try that by itself:</p>
  
  <pre><code>Private Sub city_no_AfterUpdate()  
  seat_no = "XXX"  
  End Sub  
  </code></pre>
  
  <p>Still nothing. I'm clearly missing something simple and trivial. I appreciate all the help. I've been working on this in my spare time as a personal project, using Access/VBA for the first time. I have about 4 hours into this project trying to learn it from public sources.</p>