PDA

Click to See Complete Forum and Search --> : MS Access Zip Code Look Up


bezaman
Feb 26th, 2004, 11:37 AM
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.

salvelinus
Feb 26th, 2004, 11:48 AM
"SELECT city, state FROM ZipTable WHERE zip = '" & txtZip & "'"