I need to open a form if they click on a button called "next" if the condition is they have selected "yes" from a radio button. If they have clicked "no" then after clicking the "next" button it would open a different form
Click yes = form1
Click no = form2
In both situation I need to close the current form while opening a new one based on the seletion.
Here is the code I have now...as you guessed it's not working
Private Sub Command1_Click()
If Me.Frame77 = True Then
DoCmd.OpenForm "s6_Form6"
End If
If Me.Frame77 = False Then
DoCmd.OpenForm "s9_Form9"
End If
End Sub
Click yes = form1
Click no = form2
In both situation I need to close the current form while opening a new one based on the seletion.
Here is the code I have now...as you guessed it's not working
Private Sub Command1_Click()
If Me.Frame77 = True Then
DoCmd.OpenForm "s6_Form6"
End If
If Me.Frame77 = False Then
DoCmd.OpenForm "s9_Form9"
End If
End Sub