Reverse Zip Code Lookup Code Question!

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

On my Customers form I have (2) fields, one named Postal Code and one named
City
After updating the Postal Code it fills in the City.
I need this in reverse so it wil fill in the Postal Code after the update of
the City.
The below code is on the after update event of the control Postal Code, it
fills in the city.
Both controls are Table/Query drop down lists.
They both use the same table ZipCode

City = Postal_Code.Column(1)
 
On my Customers form I have (2) fields, one named Postal Code and one named
City
After updating the Postal Code it fills in the City.
I need this in reverse so it wil fill in the Postal Code after the update of
the City.
The below code is on the after update event of the control Postal Code, it
fills in the city.
Both controls are Table/Query drop down lists.
They both use the same table ZipCode

City = Postal_Code.Column(1)
Click to expand...

I don't think this is a very good idea, Dave.
Some cities (probably most) do have more than one zip code.
Just look at the number of Zip codes in a medium size city
(Pittsburgh, PA - 77) to get an idea of what's involved in a major
city (New York, NY - 163)
You'll need more criteria than just the city.
 
Back
Top