Drop Down Boxes

[Simon]

Hello Again!

Got another one for whoever is great and powerful enough to answer
this!

In access, can you create a combo box that appears (or becomes active)
based on the list provided in another combo box?

For example, if I wanted a drop down that had a list of companies,
e.g., SUN, IBM, Microsoft. Once I had selected Microsoft, then another
list becomes available for me to choose a product, e.g., Word, Excel,
Access and then they are stored in the database table I assign to.

If you can, please say yes along with some idea on how to do this
since I cannot find out how!!!

Many thanks in advance.

Simon

[Pieter Linden]

http://www.mvps.org/access/forms/frm0028.htm

[Chuck Van Den Corput]

On 10 Nov 2003 03:11:22 -0800, aa*****@the-mdu.com (Simon) wrote:

Hello Again!

Got another one for whoever is great and powerful enough to answer
this!

In access, can you create a combo box that appears (or becomes active)
based on the list provided in another combo box?

For example, if I wanted a drop down that had a list of companies,
e.g., SUN, IBM, Microsoft. Once I had selected Microsoft, then another
list becomes available for me to choose a product, e.g., Word, Excel,
Access and then they are stored in the database table I assign to.

If you can, please say yes along with some idea on how to do this
since I cannot find out how!!!

Many thanks in advance.

Simon

Have an event trigger after the first combo box is set with a company
name. The event would define the rowsource of the second combo box,
based on the contents of the first combo box.

Chuck