title: Write conflict in very simple Access form with subform
body: <p>This one is stumping me because what I'm doing seems so straightforward.</p>
  
  <p>I have an unbound form (<code>frmAdmin</code>) with a listbox (<code>lstUsers</code>) and a subform that also contains a listbox (<code>lstUsergroups</code>).</p>
  
  <p><code>lstUsers</code> is unbound and shows a list of usernames (row source is the users table left joined with the contacts table on <code>users.fk__ContactID = contacts.pk__ContactID</code> so I can get the names to display)</p>
  
  <p>The subform is bound to the users table and has the filter <code>pk__UserID = Forms!frmAdmin!lstUsers</code></p>
  
  <p><code>lstUsergroups</code> shows a list of usergroups as is bound to the <code>fk__Usergroup</code> field in the users table.</p>
  
  <p>The only VBA involved is a click event on <code>lstUsers</code> that requerys the subform.</p>
  
  <p>When I select a user from <code>lstUsers</code> the subform listbox shows the user's usergroup selected, but if I select a different usergroup and then select a different user or close the form I get the write conflict "This record has been changed by another user" etc.</p>
  
  <p>This seems so simple! What could cause a write conflict? There are no other forms open, the users table is a linked SQL Server table but there are no triggers anything that should be writing to it. It's just a form, a subform, and a click event.</p>