Cascade Option Group

[air1access]

I'm sure I should be cascading comboboxes, but I'm tryin' to do a similar thing with an option group. Meaning a combobox is used to make a selection, and then an option group is updated/refreshed - only showing the options based on the combobox selection...
Any suggestions or examples..??
Thanks in advance..!!!
air1access

 

[fneily]

You state "option group is updated/refreshed - only showing the options". An option group can only show one selected option.

If you have multiple options to show, you would just use the "option button" control to create your options.

Then on the AfterUpdate of the combobox, you could have something like:
If DLookup("[male]", "[customer_table]", "[fname] = " & Chr(34) & Me![Combo0].Value & Chr(34)) Then
Me![male1].Value = True
Me![female1].Value = False
Else
Me![male1].Value = False
Me![female1].Value = True
End If

If your combobox is showing numerics, the drop the chr(34)'s.