Add data into table/query from text box and button

[D347HxD]

Hello, I have been working on a database and so far it's going well. I have 14 text boxes that are hooked up to a button that searched a query (which is attached to a table) for what you searched. It works perfectly... though I'd like to add one more feature to this database; and that is an add button. Where if you enter information into those same text boxes, and click the add button instead of the search button it'll add a field with all that information you entered into the table, which lets the query see it and you can search for it at later times.

To see exactly what I mean in front of you, to get a better understanding of what is going on and such, the download is below to my database.
PCResale.zip

Please ignore CustomersT as it was me fooling around with tables and is 100% not needed.

Table name: OrderT
Query Name: SearchQ
Form: SearchF
Textbox Names:
- BusinessName
- DateOfPurchase
- CutplanDueDate
- HardwareSpecs
- PurchaseOrder
- OrderName
- EngineerDueDate
- MaterialSpecs


- HardwareDueDate
- PurchaseSupplier
- OrderDesc
- ProjectComplete
- CutplanCode
- HardwareComplete
FieldNames:
All same as above text box names.
Button Name: Command344

Windows 7
Windows Access 2013

If you need more information, please ask.

[hrenee]

I highly suggest you stop. Read this http://www.accessmvp.com/Strive4Peace/Index.htm and this http://www.rogersaccesslibrary.com/f..._topic436.html before going any further. Your data is not normalized, there should be many more tables with relationships than what you have.

Good luck and have fun reading.