Interactive Form Control Question

[baadams]

I've got two bound form controls on a subform in datasheet view. For example cmb_Size and cmb_Color. I want the values in cmb_Color to change when cmb_Size is changed. cmb_Size has set values but the values in cmb_Color can change depending on what's selected for cmb_Size. I hope that explains it well enough. I can get a list in cmb_Color to populate but it doesn't change if I change the value in cmb_Size.

I feel like I've seen this question before but can't seem to find it. Thanks for the help.

 

[jackd]

When the values available are dependent on a selection made in another combo, these combos are referred to as Cascading Combo boxes.

There is a free video tutorial for 1 combo and cascading combo at
http://www.datapigtechnologies.com/flashfiles/combobox1.html and
http://www.datapigtechnologies.com/flashfiles/combobox2.html

Good luck

 

[baadams]

Thanks! I'll have to try that tomorrow. I think the requery event is the missing part. I assume this will work with a form that's in datasheet view.