Greetings all,
When I create a form to search for inventory in my DB, everything seems to work fine. I use the following for the search criteria on the Search Form:
Code:
Like "*" & [Forms]![G-Gun_SearchF]![Description] & "*"
However, when I COPY a Query, paste it, rename it then change all of the data fields to correspond to the correct table... it just doesn't work at all. I always have to re-create the query from scratch which is a big pain in the ass especially when it comes to time and formatting.
At any rate, I've recently stumbled onto a problem where some of my Queries aren't functioning properly. For instance, on my Search Form, when the user types in a value to search for and clicks the Search button, it simply throws up a small popup window asking for another search value. I'm not understanding why this is happening to some of the search forms/queries and not others.
I'm fairly certain I've edited all of the relative data fields, linked tables, etc.
Here is a snapshot of the 'extra' window that keeps poping up:
Ideas? I have a search form that works perfectly. However, when I try to duplicate it, edit it accordingly to the next set of data/table/query/etc, it never seems to function properly.
Thanks.