|
[Still a problem for me, I can't believe it's form corruption now - any
ideas? Really difficult to deal with as I can't trap the error!]
I'm having this problem when closing a form that I really don't think should
be happening;
This is the last section of code in the afterupdate of a combo box in form
frm_Agency;
DoCmd.openform stDocName
DoCmd.Close acForm, "frm_Agency"
exit_err_cboYear_AfterUpdate:
Application.Echo True
DoCmd.SetWarnings True
Exit Sub
err_cboYear_AfterUpdate:
MsgBox Err.number & " " & Err.Description
Resume exit_err_cboYear_AfterUpdate
Another form is opened then frm_Agency is closed. When I step to the Exit
Sub it gives;
"2450 Microsoft Access can't find the form 'frm_Agency' referred to in a
macro expression or Visual Basic code." This error is coming from the
current event of the form but I don't see how as the current event is not
being invoked at this point.
I have this sort of code running fine everywhere else. What's going on?
I'm in hair-pulling mode at the moment.
many thanks
Martin
| 
