Trouble With User Query

[wolfm]

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.

[orange]

Do a compact and repair on your database, then create a zip file.

[June7]

If file still too large after those steps, can upload to fileshare site such as Box.com and post link.

Options for the filtering:

1. dynamic parameterized query references form controls for input, review: http://datapigtechnologies.com/flash...mtoreport.html

2. use VBA to construct filter criteria string, review: http://www.allenbrowne.com/ser-62code.html

[wolfm]

OK Here goes. File attached...

[orange]

Suggest you adopt a naming convention that only allows alpha and numeric characters and underscore "_". Special characters like space/blank and "#" will cause you all sorts of syntax errors. Change now, you'll be glad you did.