creating pull down menu in a form in Access

[kath0178]

I am new to Access (using the 2000 version). I have created a form and I was
wondering if Access will "do the work for me" in some of the fields.

Is it possible to enter a zip code in a certain field and have the state
automatically pop up in the state field? If not, how can I create a list of
selections for the state abbreviations and others fields that I will need?
Is there a max of how many can be listed (no more than 10 needed)?

I don't think I will need it so one depends on the other (if they select
option A then the next drop down box is a different list) except for the
state/zip relation.

Hope this makes sense.

 

[Damian S]

Hi kath0178,

Sounds like you want to use a Combo box that is populated from a table
containing states/post codes. In Australia you can download this list from
Australia Post, if you are somewhere else, you should check with your local
postal service to see if you can do this. It's then a simple task to put a
combo box on your form to display them.

You can include a filter function to restrict the list to a certain post
code if you feel it's necessary.

Damian.

 

[missinglinq via AccessMonster.com]

Actually, once you have the zipcode table, all you have to do is include it
in the query underlying your form. Join the zipcode field of your main table
and the zipcode field of the zipcode table, then when you enter the zipcode
in your form, the city and state will be filled in automatically. You need to
google "zipcode datatbase Access" and you'll find a bunch of comercially
available products. They usually only run $15-30, and besides the zipcode,
city and state also usually include Area Code and sometimes other data. If
you're only dealing with a VERY limited area, you could create and fill in
your own table.

Hi kath0178,

Sounds like you want to use a Combo box that is populated from a table
containing states/post codes. In Australia you can download this list from
Australia Post, if you are somewhere else, you should check with your local
postal service to see if you can do this. It's then a simple task to put a
combo box on your form to display them.

You can include a filter function to restrict the list to a certain post
code if you feel it's necessary.

Damian.

I am new to Access (using the 2000 version). I have created a form and I was
wondering if Access will "do the work for me" in some of the fields.

[quoted text clipped - 9 lines]

Hope this makes sense.

 

[Damian S]

That is technically correct, but won't work here in Australia were we have
multiple locations (city/suburb) for each post code, hence the need to filter
a combo box.

Damian.

Actually, once you have the zipcode table, all you have to do is include it
in the query underlying your form. Join the zipcode field of your main table
and the zipcode field of the zipcode table, then when you enter the zipcode
in your form, the city and state will be filled in automatically. You need to
google "zipcode datatbase Access" and you'll find a bunch of comercially
available products. They usually only run $15-30, and besides the zipcode,
city and state also usually include Area Code and sometimes other data. If
you're only dealing with a VERY limited area, you could create and fill in
your own table.

Hi kath0178,

Sounds like you want to use a Combo box that is populated from a table
containing states/post codes. In Australia you can download this list from
Australia Post, if you are somewhere else, you should check with your local
postal service to see if you can do this. It's then a simple task to put a
combo box on your form to display them.

You can include a filter function to restrict the list to a certain post
code if you feel it's necessary.

Damian.

I am new to Access (using the 2000 version). I have created a form and I was
wondering if Access will "do the work for me" in some of the fields.

[quoted text clipped - 9 lines]

Hope this makes sense.

 

[missinglinq via AccessMonster.com]

Actually, Damian, my reply was aimed at kath0178 who didn't indicate that she
was in Australia. What a pain that must be for you, Down Under, to have
multiple locations for the same post code! Who in the world thought that up?

 

[Damian S]

I guess since we are such a geographically large and dispersed country we end
up with multiple locations with the same post code...