title: Handling an output error in Access
body: <p>I'm generating a query and report through VBA.  I have an option of asking the user if they want to output the report as a snapshot.  I first ask them if they want to make a snap shot.  If they say no, nothing happens.  If they say yes, they get a prompt asking where they want to save it.  </p>
  
  <p>Everything works great except if they say yes and then click Cancel on the prompt, it raises a runtime error 2501 saying the report action was cancelled.  Here is the code.</p>
  
  <pre><code>DoCmd.OpenReport "CONCERNS", acViewPreview, lstFee.Value &amp; " DETAILS"
  If MsgBox("Do you wish to create a snapshot of this report?", vbQuestion + vbYesNo) = vbYes Then
      DoCmd.OutputTo acReport, "CONCERNS", "SnapshotFormat(*.snp)", ""
  End If
  </code></pre>
  
  <p>This is also the end of my procedure so I don't really care if an error happens here since all the important stuff happened already.  I just know some monkey somewhere will flip if they ever see it.  Is there a way to handle this error?  On Error Resume Next is not an option because that would make debugging a nightmare in the future.  It sounds like I'm looking for something like a Try/Catch but I don't think VBA supports that.</p>