Hi,
Having problems using two combo boxes, the second dependent on the 1st. Have got it working for single forms as in the example from
http://www.blueclaw-db.com/access_de...pdown_list.htm
However, when using this technique in a (continous) subform within a main form, changing the first combo box in any of the records changes the second combo box in ALL the records, not just the one bring currently edited.
The bottom of the page refers to a further future article as there is a hint that more work has to be done! But I can't find it anywhere.
Can anyone point me in the right direction? I'm guessing you need to change the rowsource of the second droplist afterUpdate? EIther that or use OnCurrent to re run the query for the second drop-down lookup on each record?
Sorry for the bad explanation, I hope you can get the gist from the example link!!!
Thanks in advance,
Rob.
Cascading combo lists in continuous forms
