title: Access-2013 Passing data from a textbox of one form to another form's autonumber textbox
body: <p>I am having an issue with passing data from a textbox of one form to another form's autonumber. I am also very new to Access DBs and I am trying to learn them and right now I am stumped. </p>
  
  <p>What I mean by this is that when I double click in the list on the First form (<code>Form1</code>) I pass data from Form1 to Form2 and the rest of the variables will be updated, except for the variable <code>TI_ID</code>, since this is an autonumber. It is also the <code>primary key</code> as well and the data is taken from a query that is used with 3 tables. </p>
  
  <p>This is the VB Event I have made for the double click.</p>
  
  <pre><code>Private Sub TI_List_DblClick(Cancel As Integer)
  DoCmd.OpenForm "ImportData"
  
  Forms!ImportData.TI_ID = Me.TI_ID
  Forms!ImportData.Know_ID = Me.Know_ID
  Forms!ImportData.TI_Title = Me.TI_Title
  </code></pre>
  
  <p>It will complain and give me a runtime error </p>
  
  <pre><code>'438' Object doesn't support this property or method.
  </code></pre>
  
  <p>On Form 2, i have 3 text boxes as above and a ListBox, When you select s row in the list box, it automatically updates the textboxes up above. The issue is that again the other 2 text boxes (<code>Know_ID and TI_Title</code>) will update, but the <code>TI_ID</code> will not so if we change the title it will always save the data to the first <code>TI_ID</code> and then move to the next.</p>
  
  <pre><code>Private Sub SearchResults_Click()
  
  TI_Title = SearchResults.Column(0)
  'TI_ID = SearchResults.Column(1)
  Know_ID = SearchResults.Column(2)
  
  
  End Sub
  </code></pre>
  
  <p>As you can see the <code>TI_ID</code> part of the List_Box will not work as well and leads to problems.</p>
  
  <p>I have noticed that on the Form Footer on Form2, I can move the record forward and back and even use the Search to find the number i want. This will also update the other fields. When I click a box that updates the record, it updates the correct record.</p>
  
  <p>Is there a way that I could trick the double click to instead of trying to set the value, but to search for the data, that should have the identical number to the same field on the first one without a popup? Also if I can do this, can I do this with Form2's textbox to do the same thing? Is there an easier way that I am missing?</p>