Cascading Combo Boxes

[JerSand]

I should be embarrassed to post this inquiry inasmuch as a search yielded about a dozen related questions posted in the past. But I still don't get it and am hoping that a description of my specific situation may elicit some help.

I have a list of 12 agencies. Within each agency, there are departments ranging in number from 2 to 15.

I would like to enable the user to first select an agency from a combo box list and then be sent to another combo box list of the departments within the selected agency. Then, upon selection of the department, I would like the application to automatically return the user for another round of selection of agency and department.

I have created a table of the agencies, from which I would create the first combo box. I have also created separate tables of 12 sets of departments from which combo boxes (on separate forms, I've imagined) would present those selections.

To begin with, I'd be gratful to hear if this is the correct beginning. Or should I instead be working with queries and the requery function?

I'm weak on VBA, so the most dumbed-down approach might well be best for me. In any case, I'd be grateful to hear either how-to advice specific to my situation or simply the details of some success stories.

Thanks.

JerSand

 

[markphsd]

Hey JerSand,

I hope this is helpful. Its a easy solution, that will work just perfectly I think.

Excusme for rephrasing it some what, but I'm a poor listener. You have 12 agencies who have various attached departments assinged to them. Apparently you want to work with those departments in some sort of way, but I'm not sure.

What I would do is create a form with the 12 agences in a combo box. I would then create a sub form that had the Departments. Depending on what you want you could put a combo box in the subform and filter out the departments in the from the information supplied by the main form; or you could make a continous form with the departments listed. You don't need to use VBA, you just need to set the Child and Master Links. Once you have focused on the correct department in the correct agency, you can begin your work.

 

[JerSand]

Thank you for your suggestion, markphsd. Your listening skills seem just fine. Your idea makes great sense and is nicely tailored to my skill level. I'm grateful.

JerSand