I am creating a database for orders.
I want the users to be able to enter data in 1 textbox on the form and click 1 button and it show records with the same exact data.
Form: frmCurrentOrders
Search Textbox: txtSearch
Command button: btnSearch
Table that has data: Quote
Fields on Quote table that have data all are TEXT fields
Quote
QuoteINC
QuoteKSR
QuotePurchaseOrder
QuoteCRQ
So i want them to be able to enter any of those 5 and be able to get a record. Any help would be appriciated as I am pretty numb from all the data on the internet right now.
Thanks
Mel