title: Access Form having Write Conflict issue when checking a checkbox in a form
body: <p>I have an Access form where users can add new phone numbers for a client. So the form works in the following ways:</p>
  <ol>
  <li>There is a main form called <strong>Update Client Details</strong> which contains a subform called <strong>Update Phone</strong> which shows the list of phone numbers the Client has. Following are the fields in the form:</li>
  </ol>
  <pre><code>[cID][FullName][PhoneType][PhoneNumber][Active]
  1     Test ter   Mobile     0899955522    []&lt;=(blank check box)
  </code></pre>
  <ol start="2">
  <li><p>There is an <strong>Update</strong> button on the form that opens a new form where users can add a new phone number for the client.</p>
  </li>
  <li><p>When the user adds a new phone number, the phone number is displayed in the <strong>Update Phone subform</strong> with Active being 0 by default (Active is a checkbox field).</p>
  </li>
  <li><p>Whenever I click the checkbox to make the phone number active I receive the write conflict error.</p>
  </li>
  </ol>
  <p>Please find the attached image:</p>
  <p><a href="https://i.stack.imgur.com/m9fwj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/m9fwj.png" alt="WriteConflict" /></a></p>
  <p>I'm the only user currently working on the database. Can someone please help me solve the issue? Thank you all in advance.</p>
  <p><a href="https://i.stack.imgur.com/ZMOB2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZMOB2.png" alt="UpdatePhoneSubform" /></a></p>
  <p><a href="https://i.stack.imgur.com/meM9z.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/meM9z.png" alt="AddNewPhoneNumber" /></a></p>
  <p><a href="https://i.stack.imgur.com/9JVwc.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9JVwc.png" alt="Back to Update Client Details form where new number is shown in Update Phone subform" /></a></p>
  <p><a href="https://i.stack.imgur.com/uGoBE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uGoBE.png" alt="Wherever trying to check the checkbox it's giving the write conflict error" /></a></p>