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!