Creating one loop to control multiple conditional/cascading combo boxes

[rhuseman]

On my form I have 24 combo boxes ( 12 of which are conditional/cascading combo boxes dependent on the users input of the other 12 combo boxes).


I've found ways to do it by code each individual combo box ( http://stackoverflow.com/questions/7624318/vb-net-cascading-comboboxes-connected-to-dataset-from-access-changing-units). But I would really like to lean the code out and have it all in one spot.

I was thinking about putting this code in the form_afterupdate event. What do you think? Let me know if you need more information.

[rhuseman]

Here is a video to help clarify.

http://www.youtube.com/watch?v=0YVeL...hannel&list=UL

[zmbd]

I know that in VBA I can call a sub and pass information to that sub or function. I would suspect that you should be able to do the same for your dot-net.... so I would think that in the afterupdate event of the CBO on the right (parent) that you could call the sub to update the child CBO passing to it the information from the parent.
Not being conversant in dot-net I'm afraid that's all I can offer; hopefully someone here with more understanding will be of more help or maybe I've been able to tickle the ole-brain cells :)

[rhuseman]

give me an example of what of the vba code would look like if at all possible. I might be able to translate it.

If anyone else has any ideas/thoughts please share

[zmbd]

rhuseman:
What I would do in VBA is use the parameters part of the sub statment to pass into the call the information I needed for the conditions. Here's the basic syntax and an example: Sub Statement.

Now, because you have so little information about what your record sources are for the combo boxs it is impossible to provide more than the outline/pseudo-code:

Sub Z_Example (byval "strTblNam" AS String, _
 byval "strCallingParent")
 
'<Some code here to Declare the variables record sets/>
 
'<Some code here to trap errors/>
 
'<Some code here to create an SQL based on the table name
'   in Access I'd call the table definition to fetcht
'   the field names./>
 
'<Some more code here to to set the child/> 
 
'<Some more code to do what ever/>
 
END SUB