Dependant Combo Boxes

[spudpeel]

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.

Thanks

[missinglinq]

The concept is called cascading comboboxes. Take a look at this tutorial on our site and see if it helps:

http://www.thescripts.com/forum/thread605958.html

Welcome to TheScripts!

Linq ;0)>

[spudpeel]

Thanks so much! Got that working nicely!
: )