title: keep cursor same position in field after requery
body: <p>I'm trying to do a <code>autocomplete combobox</code> like this in the <code>keyUp</code> event.</p>
  
  <pre><code>Private Sub Combo59_KeyUp(KeyCode As Integer, Shift As Integer)
      If Len(Combo59.Text) &gt; 2 Then
          Combo59.RowSource = "SELECT City FROM Mills WHERE City LIKE '%" &amp; Combo59.Text &amp; "%' GROUP BY City ORDER BY City;"
          Me.Dirty = False
          Combo59.Requery
      End If
  End Sub
  </code></pre>
  
  <p>The problem is that after the requery, it selects all the text in the field so when the user press the next key, it erases everything.</p>
  
  <p>Is there an easy way, or I have to find the cursor position and put it back after the requery?</p>
  
  <p>Thank you</p>