enabling cascading comboboxes in datasheet or continuous form (1 Viewer)

Status
Not open for further replies.

CJ_London

Super Moderator
Staff member
Local time
Today, 17:54
Joined
Feb 19, 2013
Messages
16,553
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.
 

Attachments

  • ContinuousCascadingCombo.mdb
    448 KB · Views: 1,731
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom