Expandable option group?

[Dan2kx]

Hello,

Is it possible to create an option group/frame that reacts to data in a table?

So that as things are added to said table the option group (on a form) would automatically expand.

Is this possible?

Thanks

[ADezii]

I imagine that it would be possible, but rather difficult since you would have to dynamically create the Controls within the Option Group, position them Vertically, then Resize the Option Group itself for each new condition You may be better off displaying the Maximum Number of Options, then Enabling/Disabling them depending on specific circumstances.

[Dan2kx]

yeah sounds like a minefield, ill just have to do it the boring easy (less dynamic) way..
Thanks anyways...

Dan

[ADezii]

If I get a chance, I'll flirt around with the idea. What would probably make it even more difficult is that you would have to 'Bind/Attach' the Controls to their Parent Option Group while positioning them within the confines of the Group.

[Dan2kx]

If its too difficult then i wouldnt trouble yourself, i thought it might have been easy, i thought (briefly) the wizard could read from a table and obviously not...
in my current scenario i doubt that it the table would be updated, i just wonderered/wanted it for complete-ness, im sure you can understand that...

Dan

[NeoPa]

I had a quick look at the other available controls, but couldn't see one to cover this. Maybe a google for MS Access controls would yield something, but be careful to avoid ACLs (Access Control Lists).

[ADezii]

How about an Unbound Sub-Form consisting of a Yes/No Field and your Variable Number of Options within a 2nd Field? You can easily change the number of Records in the Sub-Form depending on your specs by modifying the Record Source, write code to make sure that only a single Yes/No Field is selected, then manually write the Value to a Table depending on the Option chosen. A little extreme, maybe? (LOL). I made a feeble attempt to dynamically create a Variable number of Options within a Group, and I feel as though it would be quite difficult, at least for me.

[NeoPa]

@ADezii
Uh oh. If ADezii says that it's a good chance this is something to avoid.

[Dan2kx]

LOL, definately not worth spending time on then...