I have created a MS Access Database and a Data-entry form. In order to make it less time consuming to the user and avoid errors, I would like to have the State, Zip, and County automatically fill in when the user enters the City. I was able to do this with a Select Case statement. But...if other cities need to be added later, this will require recoding within the program. I would like to create a separate table in the database to store the City, State, Zip, and County fields and search for the needed fields when they city is entered. Is there any way to do this with a Search or Select Statement???? I'm getting a little aggravated with the Help menu. Thanks!