Unbound Cascading Combo Boxes

[cathywoodford]

Hi. How do I go about coding 2 unbound combo boxes with the 2nd items
being based on the first selection? I have a cboInstrument and a
cboSpecificInstrument - cboSpecificInstrument should be based on the
selection from cboInstrument?

Thanks,
Cathy

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "CascadingComboBoxes.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[cathywoodford]

Hi Roger...maybe I'm looking at this wrong but this only shows how to
use it with a combo box that is bound - both my combos are unbound?

Cathy

 

[Rick Brandt]

Hi Roger...maybe I'm looking at this wrong but this only shows how to
use it with a combo box that is bound - both my combos are unbound?

The cascading aspect of "cascading ComboBoxes" is all due to their RowSource
properties. This has nothing to do with whether they are bound are not
which is determined by their ControlSource properties.