G
Guest
Have the following:
Me.Visible = False
DoCmd.OpenQuery "SelectCategory", acViewNormal, acReadOnly
DoCmd.OutputTo acOutputQuery, SelectCategory, , , yes
DoCmd.Close acQuery, "selectcategory"
DoCmd.Close acForm, "SelectCategory"
DoCmd.OpenForm "Main_Search", acNormal
DoCmd.Maximize
When the OutputTo prompt comes up and you choose to cancel instead of
exporting the data out of Access, I am receiving the following:
Run-time error '2501':
The OutputTo action was canceled. Then I can end or debug.
How do I force it passed this so that it gets to the close query etc and
gets the user back to the main form?
Thanks in advance for the help!
Me.Visible = False
DoCmd.OpenQuery "SelectCategory", acViewNormal, acReadOnly
DoCmd.OutputTo acOutputQuery, SelectCategory, , , yes
DoCmd.Close acQuery, "selectcategory"
DoCmd.Close acForm, "SelectCategory"
DoCmd.OpenForm "Main_Search", acNormal
DoCmd.Maximize
When the OutputTo prompt comes up and you choose to cancel instead of
exporting the data out of Access, I am receiving the following:
Run-time error '2501':
The OutputTo action was canceled. Then I can end or debug.
How do I force it passed this so that it gets to the close query etc and
gets the user back to the main form?
Thanks in advance for the help!