Re: Closeing form problem

Jens Schilling wrote:

Hi,

Salad wrote:

I have an A97 MDB that I converted to A2003 yesterday. My MainMenu
calls ARInfoForm. I hit the Exit button in ARInfoForm and it closes
and displays/activates the MainMenu just fine.

The ARInfoForm has a complicated recordsource that makes reference to
a couple of checkboxes on the ARInfoForm. Like
Forms!ARInfoForm!CheckBox = True

In A2003, when I open the form ARInfoForm and close it via the Exit
button it appears to close, displays/activates the MainMenu and then
it pops up behind the MainMenu and I am prompted to enter the value
for the parameter
Forms!ARInfoForm!CheckBox

Do you have any idea why it appears to execute a call to the
recordsource of ARInfoForm when it closes...like it's doing a requery
on a closed form? My Exit button is simply
Docmd.Close acForm, Me.Name

There's no Unload event and in the OnClose event I simply check to see
if another form open and if so close it. There's no Before/After
update event for ARInfoForm.


Sounds like the behavior described here :

http://support.microsoft.com/kb/811860/en-us

Regards
Jens


Thanks Jens. I was excited thinking I had a solution.

It's worked forever with A97. I called up someone, after reading your solution, who has WinXP and the app in A2003 and it closes without a parameter value and no mods to the app.

The person's computer I am testing this on uses Win2000. The KB article mentioned the bug as a problem with WinXP. So I tested it on his machine. If I use the Docmd.Echo solution I still get the parameter box. If I remove the Docmd.Echo and then use the X button to close, it freezes up on me...I see a couple of flashes and movements in the form (I guess the main menu form attempting selection then it dies).

I've thus determined A97 works fine no matter what the OS (Win2000/XP), works fine on WinXP/A2003, and fails on Win2000/A2003. Argggg!




.

Quantcast