Problem with lookup database
I have two lookup databases. One for city codes and one for county codes. When I enter the name of a city in a text field, the city and county codes should appear in the proper areas. This is a recent problem. When I enter new information into the database and leave, there seems to be no prolems. However, If I sort it, as to put in alphabetical order, the information is no longer found.
This is a new one on me. I have been doing this for years. Anyone have any ideas.