By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,654 Members | 1,811 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,654 IT Pros & Developers. It's quick & easy.

Expandable option group?

100+
P: 365
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
Mar 29 '10 #1
Share this Question
Share on Google+
8 Replies


ADezii
Expert 5K+
P: 8,634
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.
Mar 29 '10 #2

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

Dan
Mar 29 '10 #3

ADezii
Expert 5K+
P: 8,634
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.
Mar 29 '10 #4

100+
P: 365
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
Mar 29 '10 #5

NeoPa
Expert Mod 15k+
P: 31,487
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).
Mar 29 '10 #6

ADezii
Expert 5K+
P: 8,634
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.
Mar 29 '10 #7

NeoPa
Expert Mod 15k+
P: 31,487
@ADezii
Uh oh. If ADezii says that it's a good chance this is something to avoid.
Mar 29 '10 #8

100+
P: 365
LOL, definately not worth spending time on then...
Mar 29 '10 #9

Post your reply

Sign in to post your reply or Sign up for a free account.