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

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 02-25-2015, 08:33 AM   #1
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 10,905
Thanks: 40
Thanked 3,538 Times in 3,419 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
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, 818 views)

__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is online now   Reply With Quote
The Following 5 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)
Old 10-01-2017, 05:47 PM   #2
Scott_Hall
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   Reply With Quote
Reply

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:35 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
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