I have a form that needs to either open a report if one condition is met or open a form if that same condition is not met. i can do one as well as the other but I can't get them to work together. There seems to be an issue using Openform and Openreport together. Any help is appreciate. This is what I have so far:
Private Sub RCRA_Continue_Click()
If Me.[dot_transport?] = "-1" Then
DoCmd.OpenForm "frm_DOT"
Else
DoCmd.OpenReport "output"
End If
End Sub
The condition is DOT_Transport? and the Form is frm_DOT while the report is Output.