I have a form with about 20 option buttons. In some instances, when
the form is opened, only 1 option button is enabled and the others are
disabled. This is controlled by criteria from another form.
I did this by writing
Forms![Options Form].Option5.Enabled = False
for all the options that I wanted to be disabled
and
Forms![Options Form].Option3.Enabled = True
for the one to be enabled.
I did this for all the options that could potentially be disabled and
I think it must be a very sloppy way to do it, even if it does work.
I would like to be able to send the option number to one function that
would disable all the options and enable the one option that was sent.
I tried sending Option5 as a string but that didn't work. I really
don't know enough about access to figure this out so if someone could
help I would really appreciate it.
Thank you,
J Green