Help Needed - Linking a User Selected Option to Another Form

[Tmcgee923]

I have created option buttons that I would like to link to other forms. For
example, if a user selects Option A, The Option A form would pop up on their
screen; if the user selects Option B, the Option B form would pop up on their
screen, etc. I am a new user of Access 07 and am struggling finding this in
the various resources I've looked at up to this point. I would greatly
appreciate any help anyone is able to provide.

 

[Rick Raubenheimer]

Option buttons are not a good choice: The user would normally expect to use
command buttons to pop up other forms.

If you want to use Option buttons for this, place them in a group box.
Respond to the click event on the checkbox but look at the value of the group
box to see which option button was selected. (The "value" of the option
button is allocated to the group box. The easiest way to do it to is to make
sure the "Wizard" button is selected in te Toolbox, then create a group box:
The Wiz will walk you through it)

RICKgards