On my attached database, I want the user to search for any item they want, and the query to pull up all orders in "Load List" table with matching that item's description.
What I would like to do is modify the query "Part Query" to allow a user to enter their own criteria. I am told through internet search that I must go through a very complicated process using forms and macros.
I have tried to do this, using the form "Find An Item" and the query "User Search Query"
When I use the search form, it pulls quantity from table "Load Lists" but I want it to pull description. At first the search was working (although pulling from wrong field) but now it is not at all.
This seems like a really easy thing to do but is actually complicated. I think I'm missing something.
Any help would be appreciated! Thanks!
P.S. Tried to attach my database but file size exceeds max. How can I reduce the size of my file, to attach? Tried making a copy and deleting records, but can't delete multiple records at once.