Open Report or Form depending on condition

[jheintz57]

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.

[pbaldy]

If that's a Yes/No field, it would be:

If Me.[dot_transport?] = -1 Then

or

If Me.[dot_transport?] = True Then

[jheintz57]

That doesn't seem to be the problem. It actually opens a print window with the "Report" as the object as the print.

[pbaldy]

If you want it on screen:

DoCmd.OpenReport "output", acViewPreview

There should not be an issue doing one or the other. If you still have a problem, can you post the db?

[jheintz57]

Perfect, don't know why I didn't even think of that....thank you so much!

[pbaldy]

Ah good, glad it helped. Welcome to the site by the way!