title: VBA for taking information from text boxes and inserting into table
body: <p>So I have an input form that I want to use to update a table with certain fields of information. I have the ID of the record automatically coming up in a text box. I have three text boxes that I need to add to the table (excluding the ID) on a button click.</p>
  
  <pre>Name
  Date
  Method</pre>
  
  <p>are the field names.</p>
  
  <pre>As_Name
  As_Date
  As_Method</pre>
  
  <p>are the text box names</p>
  
  <p>The table name is <code>POC</code>, and the ID is <code>POC_ID</code> (its an autonumber).</p>
  
  <p>So I do not want these objects (text boxes) to be bound to the table because this is a little separate "pop-up" form that comes from a form that the table, and I only want the input to be relative to the POC_ID that is already selected via the original form.</p>
  
  <p>So how do I write the vba for this to 1)check to make sure that records do not already exist....2)update the fields (listed above) with data input from the text boxes(listed above). I want to be able to use this with a button click....</p>
  
  <hr>
  
  <p>EDIT:</p>
  
  <p>actually it is one table not two; i have two forms that I want to be able to send information to the same table (different information though). this db was already built by someone else and know I have been deamed to take it over.</p>
  
  <p>I need to add a second little pop up form for additional information to be added based on new requirements (there is literally no where for me to place this on the other one). I have already done that, and used a suggested object approach to reference the first forms (from which this second "pop-up" form springs from) to add the relative id fields. Now I have this second little pop up form that just asked three values to be inputted (which are the ones listed above).</p>
  
  <p>I just simply do not know how to link the text box, with a field so that once a user enters in the information, clicks "save" it saves the information to the table relative to the TripID that is there (one mentioned above). the only way I know how to get the text boxes to save data to the table is to use the builder/wizard when I create a new one.</p>
  
  <p>I would like to learn how to link an object (text box, cmb, list) etc on a form, to a table with an "On Click" method so that I can use a save button. Basically that is it!</p>