I was wondering if anyone could tell me what Error 2585 meant. I want to add code to send email to the remote user from the click (Yes) event of the form close.
Here is the code:
DoCmd.Restore
Select Case intReturned
Case vbYes:
' Now mark those items selected as "Shipped"
Call SetBusy(True)
Call RunQuery_TSB("", gCqryAppendBackOrderedItemstoOrder)
Call RunQuery_TSB("", gCqryMarkAsShipped)
Call RunQueryParameters_TSB("", gCqryqryAppendBolRecord, strBOLParmNames(), vBOLParmValues())
Call FormClose_TSB(gCfrmBOL)
Call SetBusy(False)
DoCmd.SendObject acReport, stDocName, , "dawson_mc@msn.com", , , "Bill Of Lading"
End Select
Similar code has worked elsewhere with other forms but I get an Error 2585 with this. The only code before this has the variables Dimed & defined.
Any ideas?
Here is the code:
DoCmd.Restore
Select Case intReturned
Case vbYes:
' Now mark those items selected as "Shipped"
Call SetBusy(True)
Call RunQuery_TSB("", gCqryAppendBackOrderedItemstoOrder)
Call RunQuery_TSB("", gCqryMarkAsShipped)
Call RunQueryParameters_TSB("", gCqryqryAppendBolRecord, strBOLParmNames(), vBOLParmValues())
Call FormClose_TSB(gCfrmBOL)
Call SetBusy(False)
DoCmd.SendObject acReport, stDocName, , "dawson_mc@msn.com", , , "Bill Of Lading"
End Select
Similar code has worked elsewhere with other forms but I get an Error 2585 with this. The only code before this has the variables Dimed & defined.
Any ideas?