Interdependent Combo Boxes (2000 - can be higher)

[unkamunka]

Part of the data for a Master Record draws from 2 Combo Boxes. Most of the time, new entries are needed in at least one of the Tables underlying the Combo Boxes - and these are dealt with by coding the Not In List Event.

Is it possible to link entries so that - on recurrence - the second Combo Box is populated from the first?

Combo Box 1 is in yy-mm-dd format - held as a String.
Combo Box 2 is a location.

Only one location is ever set for a particular yy-mm-dd. There can, however, be more than one Record for that particular yy-mm-dd. At the moment, I have been trying having a location field in the Table that holds the yy-mm-dd entries. If, however, that location field's Required value is set to Yes, the code for the yy-mm-dd Not In List Event no longer overrides the Not In List error.

It would seem that one needs something that runs on the "In List" Event - which, AFAIK, does not exist!

[Francois]

You can use the After Update event of combo box 1 to reset the row source of combo box 2 according combo box 1 and do a requery of combo box 2.
You can have a look at <A target="_blank" HREF="http://rogersaccesslibrary.com/download3.asp?SampleName=CascadingComboBoxes.mdb"> Roger

[unkamunka]

Merci bien. <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

For the record: a reference to the relevant "Microsoft ActiveX Data Objects Library" is required.