I created a query that is what I call the master query in the database I created. I then created separate queries (for each manufacturer we buy from) off of this query.
This query searches through three (3) tables and lists in alphabetical order the Manufacturer Company Name, our part number, our part description and the manufacturer's part number. There are six (6) values to enter in the parameter box when any of the queries are selected to run.
I inadvertently entered the wrong value in the box and pressed enter before I realize what I had done.
Now the box keeps cycling (looping) requesting the same values entered multiple times without showing the finished results.
I've tried several options for this via Microsoft support, but they don't work. The only way I've gotten around it, is by deleting the original saved query, then recreating the query and naming it the EXACT same name.
Any other suggestions for fixing this issue in the future?
Thank you,