title: Add data into table/query from text box and button [Access]
body: <p>I am looking for help on trying to add data into a table / query through text boxes and a button. Currently, there are two buttons that will be hooked up to the text boxes; Search &amp; Add.</p>
  
  <p>Search I have finished already, where it searches a query attached to a table for the input you entered into the text boxes. Simple.</p>
  
  <p>Though now I'd also like to make an add button, where once you put information into the text boxes and click add instead of search, it directly adds that information onto the table and saves it so you can view it at later points in time.</p>
  
  <p>This is code I found online somewhere, but I don't know how to make it pick up the data from the text boxes using it:</p>
  
  <pre><code>Private Sub Command344_Click()
  
  INSERT INTO OrderT (CustomerName,OrderName,OrderDesc,DateOfPurchase,ProjectDueDate,EngineerDueDate,ProjectComplete,CutplanDueDate,MaterialSpecs,CutplanCode,HardwareSpecs,HardwareDueDate,HardwareComplete,PurchaseOrder,PurchaseSupplier);
  VALUES (CustomerName,OrderName,OrderDesc,DateOfPurchase,ProjectDueDate,EngineerDueDate,ProjectComplete,CutplanDueDate,MaterialSpecs,CutplanCode,HardwareSpecs,HardwareDueDate,HardwareComplete,PurchaseOrder,PurchaseSupplier);
  
  End Sub
  </code></pre>
  
  <p>Button Name:
  Command344</p>
  
  <p>TextBox Names:
  CustomerName
  OrderName
  OrderDesc
  DateOfPurchase
  ProjectDueDate EngineerDueDate
  ProjectComplete
  CutplanDueDate
  MaterialSpecs
  CutplanCode
  HardwareSpecs
  HardwareDueDate
  HardwareComplete
  PurchaseOrder
  PurchaseSupplier</p>
  
  <p>The fields in the table have the same names in the exact same order from top -> bottom, left -> right.</p>
  
  <p>The table name is OrderT.</p>
  
  <p>Form name is SearchF</p>