My Outputto button need to add code if they hit cancel instead of ok a runtime error appears

[GinaFlan]

[Private Sub CmdReport_Click()
Select Case Me.ComboSummary
Case "Child Nutrition"
DoCmd.OutputTo acOutputReport, "Child Nutrition Monthly Report", "", "", False, "", 0
End Select]


Run-time error '2501 The output to action was canceled (it's not a big deal but there has to other cancel options)

[June7]

Options:

1. error handler code

2. create your own popup for selecting file format - assign user choice to a variable and use that variable in the OutputTo command

[GinaFlan]

I put acformatPDF

Where would I put error handler code? This will be my first error handler

This is under my command button click

[Select Case Me.ComboSummary
Case "Comptroller"
DoCmd.OutputTo acOutputReport, "Comptroller September Report", acFormatPDF, "", False, "", 0
End Select]

[June7]

If you specify the output file format, error handler should not be needed.

Here is an article for review http://allenbrowne.com/ser-23a.html

[GinaFlan]

Right ok thank you