Close Form generates an "Enter Parameter" dialog with form maximized

[Sierras]

I have a very strange problem with one of my forms.
I have a close button on the form which basically just closes the form.
And it works fine. But when I set the form's On Open event to
DoCmd.Maximize, the close button now produces an "Enter Parameter Value"
dialog - looking for Forms!frmName!IDName.

When I get rid of the On Open event, the problem goes away.
Any ideas?

 

[Guest]

The open event of a form is too early to reference any controls. You should
move the refence to the Load event.

 

[Sierras]

No there is no other event on the form or it's subform. And it also does
the same thing on Load event. I do have a few After Update events that
are used on combo boxes. But I don't think that would have anything to do
with it..

 

[Jeff Boyce]

I've run into a similar issue, and have a work-around, but not an
explanation.

If you add
DoCmd.Restore
to your OnClose event, I believe this may eliminate the parameter prompt.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Sierras]

You're right. That works for some reason.

Thanks for your help..