Nested Option Group? 1

[dswitzer]

Is there a way to nest option groups?

For instance,

Level 1 option group:
select button 1 as default, or button 2

Level 2 option group:
If button 2 on Level 1 is selected,
button 3 (a button in this Level 2 option group) is the default, else - no default in Level 2 option group.

Kind of confusing to explain.

Thanks.

 

[downwitchyobadself]

Access has no native nesting capability, but you can set it up yourself through code, using option group 1's AfterUpdate event.

Select Case MyOptGrp1
Case 1
'set a value in MyOptGrp2
Case 2
'set a different value
etc.
End Select

You can simulate the nesting pretty easily.

Hope that helps.