I am trying to write my 1st application in Access. A user selects a city from a dropdown combo box {13 choices}. I would like for the zip code to automatically fill in another box {text box I figured}. The city is being selected via a table query. The table has three fields, CitiesID - auto, Cities, and ZipCode. Does this task need to be handled with raw code? If so, exactly what statement would I use? I tried writing a statement for one city. Example...AfterUpdate, If cmdCitiesID = New York Then txtZipCode = 29653. I have also tried to use the build function, but was unsuccessful.