AnsweredAssumed Answered

Auto Enter state based On Zip Code

Question asked by crtopher on Jul 13, 2010
Latest reply on Jul 14, 2010 by philmodjunk


Auto Enter state based On Zip Code


Hi All...this is my first post (gulp)

I want to enter a zip code (or postcode as we say here in Australia) and have the state automatically entered based on the first number of the zip code. So in Australia, for eg., the State of QLD has only zip codes starting with 4, NSW only with 2, etc. So when I type, for eg., 4069, I want "QLD" entered into the state field

I have worked out how to extract the first value (Left(zipcode;1)), but i'm having trouble getting the state autoentered into the state field, once ive entered the zip code in the zip code field.

Thanks in Advance