February 9th, 2005, 09:55 PM
|
|
See this article on The ACCESS Web:
http://www.mvps.org/access/forms/frm0058.htm
--
Ken Snell
MS ACCESS MVP
"Max" wrote in message
...
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
|