title: access form won't update while combobox is being edited, must move to next record
body: <p>I have a continuous form with a list of comboboxes, pic here:  </p>
  
  <p><img src="https://i.stack.imgur.com/Z9Eko.png" alt="enter image description here"></p>
  
  <p>As you can see there is a small pencil on the left side of the access form to display that the current record in the form is being edited. I need to change this to a triangle so the other forms update properly with a button. Is there VBA to "lose focus" or change the pencil to a black triangle? I tried move to next record but for some strange reason it crashed. In addition it was fairly complex because I had to add logic if the user was on the last record, since it would throw an error because it can't go to next record on the last record. My vba is below (currently crashes access for some reason)  </p>
  
  <pre><code>with recordset
  if .recordcount=1 then
  docmd.gotorecord record:=acfirst
  
  elseif .absoluteposition = .recordcount - 1 then
  docmd.gotorecord record:=acprevious
  docmd.gotorecord record:=acnext
  else
  docmd.gotorecord record:=acnext
  docmd.gotorecord record:=acprevious
  end if
  end with
  end sub
  </code></pre>