title: MS Access runtime error 2115
body: <p>In Ms Access, I have two unbound combo-boxes: <code>StateBox</code> and <code>DVPCBox</code>.  StateBox is simply a list of U.S. states and DVPCBox contains Employee Names from a query based on the value of StateBox.</p>
  
  <p>I'm trying to set the value of DVPCBox equal to the first item in its list.  Since the list of Employees is based on the value of StateBox, I need the value of DVPCBox to update every time StateBox changes.  I tried the following:</p>
  
  <pre><code>Private Sub StateBox_AfterUpdate()
      Me.DVPCBox.Requery
      If (Me.DVPCBox.ListCount = 1) Then
          Me.DVPCBox.SetFocus
          Me.DVPCBox.ListIndex = 0 //&lt;-Error here
      End If
  End Sub
  </code></pre>
  
  <p>But I got runtime error 2115 - The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing Microsoft Office Access from saving the data in the field.</p>
  
  <p>The strangest thing to me is that I'm not even using the BeforeUpdate Event or ValidationRule (as far as I'm aware.)</p>