two drop down menu

Y

yanz

hello,
i am user of mic office access 2002.
my question is how to manage two drop down menu in access..
example:
first drop down menu will list all the country all over the world
and when 1 country have been selected..
automatically second drop down menu will list all the region in that
particular country only..
but how to do that? anyone can explain..this is my first time using access..
thanks
 
A

Allen Browne

See:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm

The core idea is to use the AfterUpdate event of the first combo to assign
the RowSource of the second.

(You might find this difficult if you have never seen VBA code, and don't
understand SQL statements either.)
 
A

Allen Browne

That's probably beyond what can be achieved in the newsgroup.

You may need to enrol in a training course for Access, or buy some books and
work through the examples, or get some training videos, or whatever format
you find easiest to learn from.

There is quite a learning curve with Access: it's very powerful, and can be
somewhat daunting, so be patient with yourself if it takes a while to learn
all about how it works.
 
Top