By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,130 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

Dependant Combo Boxes

P: 8
Hi, I am currently making a document control system through access, and yet another hurdle has come up. Rather than give the user a table to sift through, I want to be able to use dependant combo boxes to pick a document name from a list. There are two tables involved: the first contains Department codes and Department names, i.e. 1.Sales, 2.Production; and the second contains Document Details, including the Department Code.

I want the first combo box to give a list of department names, and then when this is updated, for the second combo box to give a list of the documents for that department.
I have started afresh 3 times on this, and just cannot get it to work. Could anyone suggest a really smart way of doing it? Id really appreciate some help to stop me going mad any longer.

Aug 14 '07 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,532
The concept is called cascading comboboxes. Take a look at this tutorial on our site and see if it helps:

Welcome to TheScripts!

Linq ;0)>
Aug 14 '07 #2

P: 8
Thanks so much! Got that working nicely!
: )
Aug 16 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.