Hi everyone.
I find myself stuck in a section of my project. Seeing as though the final query of my project will take roughly 15-20 mins to run (its massive), I am trying to take care of all the possible issues that can arise BEFORE the query is run. One of them is checking to see if one of the search criteria, a zip code in this case, actually exists in a table.
Since the table is so large, what I want to happen is the following:
1. take the zip code stored in Me.txtZip
2. open the "address" and search ONLY the zipCode field (again, trying to save as much time as possible) for Me.txtZip
3. If it exists, move one, else, msgbox telling the user its not there and to exit sub.
I know how to search the whole table, but the issues I'm coming accross are searching just that field, and also how to output what's essentially a boolean "exists" yes/no. Any help is appreciated.