By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,489 Members | 1,777 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,489 IT Pros & Developers. It's quick & easy.

A2K - Odd form closure problem - REPOST

P: n/a
[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
Mar 2 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.