Re: Closing an Empty Form

Sleuthing's definitely right! I don't think I've encountered anything like this before. Just as an experiment, can you temporarily alter the query by removing the three criteria that reference the main form, i.e. [Forms]![Receipts]![DEBTORID] and the other two, and see what happens?

--
Steve Schapel, Microsoft Access MVP

FJquestioner wrote:
Steve,

Not sure if this will help but this is what appears on the top of the error report I get when the system crashes.

AppName: msaccess.exe AppVer: 10.0.6771.0 ModName: msaccess.exe
ModVer: 10.0.6771.0 Offset: 000a90ad


To answer your questions...

The problem occurs whether I close the main form using the X or the macro driven Close button within the form.

I don't know for sure that the system would prompt for all 3 of the combo-box fields because as you noted, the system crashes after I cancel the first prompt. However, if I re-arrange those fields within the query, the prompt is for whichever field is left-most within the query (currently it prompts for [Forms]![Receipts]![DEBTORID] ).

Also, I recently bought a new computer and loaded Office onto it (including Access). I was having the problem of the promt appearing upon closing the form on my old computer but I don't recall it causing a system crash. However, I've re-installed Office using the "repair" mode at least 3 times and the crashing problem persists.

I'm using WinXP and I also did a system restore at one point when I was loading programs onto the new computer. That caused the Outlook program to malfunction. However, the error notice identified the problem file (one of the duplicate application files created by the restore function) and once I deleted that file it worked fine.
So I suppose its possible that the Prompt problem is a programming problem and the crash problem could be a software bug from my installation. However, all other features of Access and all other Office programs seem to be working fine.

But if I can eliminate the prompts then I needn't worry about the crashes.

Does any of this help with yur sleuthing?
.