Form within a form that controls checkboxes

[Summer123]

How can one run a form with in a form? For example I have 4 visible checkboxes in one form that control 50+ hidden checkboxes in the background and exports data to excel.
If vischkbox1 is clicked – it checks off hidchkbox1 through hidchkbox10
If vischkbox1 is clicked – it checks off hidchkbox2 through hidchkbox15
If vischkbox1 and 2 both are clicked – it checks off hidchkbox1 through hidchkbox15

And so on and so forth… that’s why I need the checkboxes…and this is working fine… however

Now the form looks big but only has 4 visible checkboxes. So what I was thinking is maybe put 50+ hidden checkboxes in a subform and make that hidden so that the original form can be formated correctly? Is there a way to do this and still have the 4 checkboxes control the 50 hidden checkboxes?

thanks!

 

[jdraw]

How did the hidden check boxes get valued? What's the application behind all the check boxes? Perhaps there are other options.

 

[bob fitz]

Hi

Why don't you just make the hidden checkboxes very small and bunch them all together, or even on top of each other?

 

[Summer123]

Hi Jdraw, ok so the hidden checkboxes run queries and with a code i basically say if the checkboxes are selected then export to excel. Does this help?

Hi Bib, yeah thats what i ended up doing is making them small but the form is still too big and i dont want to put them on top of each ther as i may have to get to them later and it will just be very confusing... any other options?

 

[bob fitz]

Hi

Hi Bib, yeah thats what i ended up doing is making them small but the form is still too big and i dont want to put them on top of each ther as i may have to get to them later and it will just be very confusing... any other options?

Nothing else springs to mind.
I would try the checkboxes on a subform control. No real need to make the checkboxes hidden. Make the Subform Control small (to gain screen space) and hide the subform control.