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