View Single Post
  #1  
Old February 9th, 2005, 09:19 PM
Max
external usenet poster
 
Posts: n/a
Default How to create a Combo Box?

I want to create a combo box where, if the user enters the zip code, the city
and state will be automatically filled in (with the option to change it,
where some towns share a zip code).

I don't need every zip code in the country, just the ones we serve. In
order to make sure I include them all, I went to the old database and created
a simple query of zip code, city and state. I got the zip code, city and
state for each of the almost 4,000 records; of course, there are duplications
of the same information where many members live in the same city!

I can't figure out where to go next with this. I have a book on Access
2002, but all it's telling me about is something called "List Boxes" and I
don't know what they are. Can someone help me by using everyday terms that I
can understand (just using the Access options, please, I am totally ignorant
of SQL, VBA, etc., except that I know I don't know anything about them!).

Thanks again, you are all so helpful!

In peace,

Max