title: "You cannot assign value to this object." with new record
body: <p>I have a VERY peculiar problem. When a new record is created and I want to select a Customer_ID from ComboBox, after selection it throws me the above mentioned error. However, it actually gets assigned (ie. everything works as it should, but for the error).</p>
  
  <p>Is there a way to bypass/disable this error?</p>
  
  <p>P.S.: This is the error: <a href="http://imgur.com/rTQC9za" rel="nofollow">http://imgur.com/rTQC9za</a></p>
  
  <p>Edit: I have located the error and it seems that it comes down to: trying to assign a value into a record that is not "confirmed" yet. That means it has no (auto generated) ID yet. Basically, how would I go about <code>confirming</code> that I want to create the said error?</p>
  
  <p>My code (to create a new record) is as follows:</p>
  
  <pre><code>'some other irrelevant code
  Dim rs As Recordset
  Set rs = Me.subOrders_for_main_overview.Form.Recordset
  rs.AddNew
  'some other irrelevant code
  </code></pre>
  
  <p>This creates a new blank record.</p>