Using radio buttons to switch between forms

[angybab]

Hi all,
I have inserted an Optiongroup in my form.
I want to use this to switch between forms.
For example if I click on option 1,
then form 1 should open, option 2
then form 2 should open, option 3
then form 3 should open,


option unknown then it should
remain on form 1.
Please can someone help?

[Bob Fitz]

The "usual" way is to use button controls to do this but you could use the following code in the After Update event of your OptionGroup control:

    Select Case Me.NameOfOptionGroupControl 
        Case 1
            DoCmd.OpenForm "Form1"
        Case 2
            DoCmd.OpenForm "Form2"
        Case 3
            DoCmd.OpenForm "Form3"
    End Select

[angybab]

Thanks Bob, it worked