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, 16:44
Joined
Feb 19, 2013
Messages
12,127
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

Scott_Hall

Registered User.
Local time
Today, 08:44
Joined
Mar 27, 2017
Messages
34
I can't believe this hasn't received more attention. Thank you CJ, this one is very handy and easy to use.
 
Status
Not open for further replies.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom