I created a form in microsoft access 2000 for data entry. I have an access table that has all US zip codes with their corresponding cities and states. What I want to do is when the zip code is entered I want search the table of zip codes and then fill in the city and state automatically. Can someone please show me some code to do this? Thanks.
