enabling cascading comboboxes in datasheet or continuous form
Having been asked about this recently, I reinvented some code I developed to work with datasheets and which also works with continuous and single forms.
The attachment was developed in 2010 but saved as 2003.
The db demonstrated two techniques for using cascading comboboxes.
Technique 1 is the simpler one and is used where the combobox displays the bound column after updating
Technique 2 is slightly more complex and is used when the bound column is not displayed after updating - which is frequently the case. However it can also be used in place of technique 1
Note that all the comboboxes need to be bound (in order to retain the values selected for each record). However if used in a continuous/datasheet form in dataentry mode or a single form, they do not need to be bound.
A little thanks goes a long way. If you have found this post useful, please tick the thanks button