Combo not allowing selection

[Rose B]

I hope that this is something simple! I have two combo boxes, user selects
from 1st and based upon that the second combo box lists values. This works
fine BUT no matter which you select in the 2nd combo box list, it always
defaults to the 1st entry in the list. What am I doing wrong?

 

[Roger Carlson]

I'm not sure what you're doing wrong here, but on my website
(www.rogersaccesslibrary.com), is a small Access database sample called
"CascadingComboBoxes.mdb" which illustrates how these work. Perhaps if you
compare my sample to yours, something will jump out at you.

--
--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

 

[Ken Sheridan]

It sounds like your second combo box's bound column might be a hidden column
which correlates it with the first combo box. This would explain the
behaviour as when you select an item in the first combo box and requery the
second, the value of the column which correlates them will be the same in
every row of the second control's list. If this is the bound column, which
determines the value of the control, then whatever row you select will result
in the control having the same value so it will select the first item with
that value. Setting the BoundColumn property of the second combo box to
whichever column contains the unique values should cure it, so if the
BoundColumn property is 1, and the first column is the hidden one you'd set
the property to 2.

For examples of different ways of using correlated combo boxes, including
hybrid controls on continuous forms, see:



http://community.netscape.com/n/pfx...yMessages&tsn=1&tid=23626&webtag=ws-msdevapps


Ken Sheridan
Stafford, England

 

[Rose B]

Thanks - I found it in the end - I just walked away and came back and went
through it all again and realised that I had bound the wrong column in the
second combo. Corrected that and all went well!