Option groups causing form corruption

[CarrieL]

Whenever I try to refer to an option group or option button on a form,
whether in a form or macro, the form becomes corrupt and I can no longer view
or modify the design. It's as if the form is no longer there.

I want to add code based on the option selected by the user. The option
group works as far as running basic code based on the response, but if I
refer to the option group in another macro, or in a text box elsewhere on the
form, I get kicked out, or the form becomes corrupt.

I currently have a major form which I can no longer access (yes I do have
backups).
Any suggestions?

Thanks!

 

[KARL DEWEY]

Refer to the option group frame.
It will output a number representing the button selected.
[Forms]![YourForm]![Frame5]

 

[CarrieL]

That's what I'm doing. For example, I create a text box on the same form and
refer to the frame (if frame=a,"print this",if frame=b, "print this"), etc.
If I go to open the form, it locks up and I can't get back into it.

I'm using Access 2003, but defaulting to version 2000 (since that's what my
user has).

Thanks.

Refer to the option group frame.
It will output a number representing the button selected.
[Forms]![YourForm]![Frame5]
--
KARL DEWEY
Build a little - Test a little

Whenever I try to refer to an option group or option button on a form,
whether in a form or macro, the form becomes corrupt and I can no longer view
or modify the design. It's as if the form is no longer there.

I want to add code based on the option selected by the user. The option
group works as far as running basic code based on the response, but if I
refer to the option group in another macro, or in a text box elsewhere on the
form, I get kicked out, or the form becomes corrupt.

I currently have a major form which I can no longer access (yes I do have
backups).
Any suggestions?

Thanks!