Here is my code, Top 20 is a form with 2 toggle buttons on it. The user then select Command135 which is a submit button, but it doesnt run anything when the submit is clicked. Cant figure out why.
Private Sub Command135_Click()
If [Forms]![Repeats Interface]![Top20].OnClick = "Install" Then
DoCmd.OpenReport "Top 20 Installation Criteria", acViewPreview
ElseIf [Forms]![Repeats Interface]![Top20].OnClick = "Repair" Then
DoCmd.OpenReport "Top 20 Repair Criteria", acViewPreview
End If
End Sub
KaayJaay
Private Sub Command135_Click()
If [Forms]![Repeats Interface]![Top20].OnClick = "Install" Then
DoCmd.OpenReport "Top 20 Installation Criteria", acViewPreview
ElseIf [Forms]![Repeats Interface]![Top20].OnClick = "Repair" Then
DoCmd.OpenReport "Top 20 Repair Criteria", acViewPreview
End If
End Sub
KaayJaay