Runtime error 2585

S

StuJol

Can someone please help

i get this error msg 'Runtime Error 2585, this action cant be carried out
while processing a form or report event

Here is my script

'If Quote Exceeds Quote Valid For Days Then Display MsgBox.

If Date >= (QuoteCreatedDate + Quote_Valid_For_Days + 1) And
Combo73.Value = "Quote Sent" Then
Dim Response3 As Byte
Response3 = MsgBox("Quote Has Exceeded Valid For Days. Status Will
Change To Quote Rejected ", vbInformation, "Work Order's Database")
If Response3 = vbOK Then
Frame384.Value = 2
Combo73.Value = "Quote Rejected" 'Status to Quote Rejected.
DoCmd.Close acForm, "Work Orders"
Else
End If
End If


on clicking ok on the msgbox certain events occurr on my form "work orders"
and them im trying to close the form. the code DoCmd.Close acForm, "Work
Orders"
is bringing this error msg up.

Does anyone know how i can close my form when the events have finished.

Thanks to anyonewho looks into this
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cant close a form 3
Form Will Not Close 1
runtime error 3
err 2585 - this action can't be carried out while processing a form or report event 1
Adding a timer in VBA code 7
How to close form if code is still processing? 4
Rename forms error 5
Error 2585 trying to close form 2

Top