The code uses ADO to load some local tables and then does a
docmd.openform and a docmd.close to close the search form. The form
being opened resets its recordset based on the ID that was selected on
the search form. The one unique thing about the form is that it uses
the spreadsheet control.

It seems that this issue is specific to Office XP Service Pack 2. We
can't recreate it on my machine that's running SP1 and when we upgraded
the QA's machine to SP3 she could no longer seem to create the issue
(she's going to do more testing tomorrow).

I've tried some of Wayne's suggestions and the error still occurred. I
also tried putting a log function in the routines being executed and my
code only runs once. I also was able to get back to Access when the
extra forms were displayed and Access only thought there was one form
open. If you try and click on one of the extra forms Access crashes.
When Access displayed its closing message we said "send report" and
followed the prompts -- the messages seemed to indicate that this was a
known problem and that we should install SP3.

-- David.