Form Unload/Close Randomness

[misseill]

Hi there,

I am currently working on converting a program from Access 97 to Access
2003. It all worked fine in 97, but there is some randomness in 2003
that I don't understand. I have a form, Main, that loads as follows in
the code:

1. In Main's Form_Load subroutine, the first line calls a routine
(PutTableOnSubform) that will load a data table's fields onto its
subform's (Template) form.
2. PutTableOnSubform's first line opens the subform in hidden mode:
DoCmd.OpenForm "Template", acDesign, , , , acHidden
3. The rest of PutTableOnSubform populates Template with the table's
fields (text boxes) and then the last line closes it up:
DoCmd.Close acForm, "Template", acSaveYes
4. Back in Main's Form_Load, the next chunk of code sets some of the
properties of the Me.subform control, like the source object (Template)
and the caption.

And then the rest of the code runs and the form loads up on the screen
fine.

My problem is, any time after the first time when I press the button to
load Main, I get run-time error 2467, "The expression you entered
refers to an object that is closed or doesn't exist".

When I step through the code on these subsequent loads, the step 2
above calls Main's form_Unload event and then the form_Close event. So
when it goes back to the form_Load event to do step 4 above, it hits
the runtime error entered.

Please tell me if I can supply any additional information in order to
get past this roadblock. Thank you in advance for your help.

Erika

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In Access 2002 & higher a form can't be opened in design view when it is
being used as a subform in an open form. The reason it works the 1st
time is the subform's Source Object isn't defined. Perhaps, if you
nulled the subform's Source Object before opening the Template form in
design view, it would work.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQkxAtoechKqOuFEgEQK7wACfUBuEe458En7prtPmVYfsmR YsJDQAn1fw
ikF0IWsK3NqODSTKB2fIamhf
=uXcF
-----END PGP SIGNATURE-----

mi******@gmail.com wrote:

Hi there,

I am currently working on converting a program from Access 97 to Access
2003. It all worked fine in 97, but there is some randomness in 2003
that I don't understand. I have a form, Main, that loads as follows in
the code:

1. In Main's Form_Load subroutine, the first line calls a routine
(PutTableOnSubform) that will load a data table's fields onto its
subform's (Template) form.
2. PutTableOnSubform's first line opens the subform in hidden mode:
DoCmd.OpenForm "Template", acDesign, , , , acHidden
3. The rest of PutTableOnSubform populates Template with the table's
fields (text boxes) and then the last line closes it up:
DoCmd.Close acForm, "Template", acSaveYes
4. Back in Main's Form_Load, the next chunk of code sets some of the
properties of the Me.subform control, like the source object (Template)
and the caption.

And then the rest of the code runs and the form loads up on the screen
fine.

My problem is, any time after the first time when I press the button to
load Main, I get run-time error 2467, "The expression you entered
refers to an object that is closed or doesn't exist".

When I step through the code on these subsequent loads, the step 2
above calls Main's form_Unload event and then the form_Close event. So
when it goes back to the form_Load event to do step 4 above, it hits
the runtime error entered.

Please tell me if I can supply any additional information in order to
get past this roadblock. Thank you in advance for your help.

Erika

[misseill]

Thank you so much!
I put the source object = "" before the puttableonsubform line, and it
loads every time.
Thank you thank you thank you!