I have a problem where i need to create a tracking database I have a main form with 12 options of which the user can select 1 each enables a combo box with up to a further 6 options. Each of these 6 options triggers a sub form with up to 5 buttons in an option group.....
what this would mean in brief is that I have a main form with up to 72 subforms !!!!!! Ugh!!!!
What I would like to do is set up all the responses in a table and give them a sub code 1a,1b,1c,2a,2b,3a,3c.........11c,1d,12a,12b,12c etc. select the reqd sub group as a recordset and insert them into an option group on a form .
Does anyone know if it is possible to create an option group from VBA and if so does anyone have any idea how to implement it ??
I Have Since Found the createControl Sheet on the KB If anyone has any examples of using this with option groups i would be most greatful
what this would mean in brief is that I have a main form with up to 72 subforms !!!!!! Ugh!!!!
What I would like to do is set up all the responses in a table and give them a sub code 1a,1b,1c,2a,2b,3a,3c.........11c,1d,12a,12b,12c etc. select the reqd sub group as a recordset and insert them into an option group on a form .
Does anyone know if it is possible to create an option group from VBA and if so does anyone have any idea how to implement it ??
I Have Since Found the createControl Sheet on the KB If anyone has any examples of using this with option groups i would be most greatful
