Connecting Tech Pros Worldwide Forums | Help | Site Map

A2k - odd form closure problem

Deano
Guest
 
Posts: n/a
#1: Mar 1 '06
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 through this
it gives;

"2450 Microsoft Access can't find the form 'frm_Agency' referred to in a
macro expression or Visual Basic code."

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



Deano
Guest
 
Posts: n/a
#2: Mar 1 '06

re: A2k - odd form closure problem


Deano wrote:[color=blue]
> I'm having this problem when closing a form that I really don't think
> should be happening;[/color]

Odd, I think it was my first experience of a corrupted form. Recreated it
and it was ok!


Closed Thread