Checkbox to select combo data

[tikkat3]

I have a form, which will use various sub forms and comboboxes. The database I am creating is to track non-conformances across the business. The combo dropdowns will be different depending upon the department selected (Engineering, Manufacture, Installations, Service). Is there a way so that if a checkbox with one of the 4 departments is selected, then the drop down results will be restricted to those suitable for the department.

In other words, if I either have a reference table with all possible results, or 4 separate tables which are department specific, can a checkbox be used to select the correct data for me and populate the drop down list in the combo?

 

[neileg]

Probably best to use a cascading combo box instead of checkboxes. Do a search on that subject in these forums.

 

[missinglinq]

Here's one tutorial on cascading comboboxes, but as Neil suggested, goggling on the term should get you a gazillion hits.

http://bytes.com/forum/thread605958.html

 

[tikkat3]

Thanks, but I am not sure that this will work properly for me. There are a number of sub forms embedded into the main form and it is the data within these subforms, which needs to be influenced by a checkbox/starting point.

 

[neileg]

Yes it will work.