How can I link/cascade combo boxes?

[Bob]

I am trying to link 3 combo boxes together so that choice in the first box
drives the options presented in the second box, and the second to the third.

Any help would be greatly appreciated!

Bob

 

[Rick B]

Do a search. "cascading comboboxes" is addressed on here all the time.


Rick B

 

[Sprinks]

Hi, Bob.

Martin Green describes it well here:

http://www.fontstuff.com/access/acctut10.htm

Hope it helps.
Sprinks

 

[Dirk Goldgar]

I am trying to link 3 combo boxes together so that choice in the
first box drives the options presented in the second box, and the
second to the third.

This page on the Access Web (a great resource for "how to" questions)
shows two methods:

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

 

[George Nicholson]

http://support.microsoft.com/default.aspx?scid=kb;en-us;289670
How to synchronize two combo boxes on a form in Access 2002 or in Access
2003

The article also includes links to Access 97 and 2000 versions of the
article.