No results are found on a search performed on a Drop Down list.
I inherited a database with my new job and it was very dirty with multiple fields being used to store one type of information. I'm working on consolidating everything to one field with a drop down list so it can't be edited and thus lost. This field was previously a pop up menu so there are some records with data not included on the list.
Now when I perform a search, no matter what selection I make from the drop down menu, the search comes back with zero records found.
Any idea on what the problem might be?