Go Back   Access World Forums > Microsoft Access Reference > Code Repository

Closed Thread
Thread Tools Rate Thread Display Modes
Old 02-25-2015, 08:33 AM   #1
Super Moderator
Join Date: Feb 2013
Location: UK
Posts: 11,330
Thanks: 40
Thanked 3,669 Times in 3,537 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
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.
Attached Files
File Type: mdb ContinuousCascadingCombo.mdb (448.0 KB, 874 views)

A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline  
The Following 6 Users Say Thank You to CJ_London For This Useful Post:
Andy.T (07-28-2015), Frothingslosh (02-26-2015), hassanogaibi (06-28-2016), MajP (01-21-2019), Scott_Hall (10-01-2017), Takunda Mafuta (09-05-2019)
Old 10-01-2017, 05:47 PM   #2
Newly Registered User
Join Date: Mar 2017
Location: Vancouver, WA USA
Posts: 34
Thanks: 7
Thanked 1 Time in 1 Post
Scott_Hall is on a distinguished road
Re: enabling cascading comboboxes in datasheet or continuous form

I can't believe this hasn't received more attention. Thank you CJ, this one is very handy and easy to use.
Scott_Hall is offline  
Closed Thread

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
enabling AND disabling one control on continuous form w11184 Modules & VBA 2 03-04-2014 08:42 AM
Enabling /Locking controls on a continuous form SalmonDB Forms 2 01-28-2013 12:15 PM
Cascading Combo Boxes in a Datasheet or Continuous Form dancole42 Forms 2 01-13-2013 06:45 PM
Cascading comboboxes in datasheet view jzacharias Forms 1 11-12-2012 05:07 PM
Cascading Comboboxes on Form Close Matty Forms 2 06-18-2004 08:19 AM

All times are GMT -8. The time now is 02:12 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World