View Single Post
  #3  
Old February 17th, 2006, 06:00 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default Multiple Instances of Form Created By Form Open

"David S" wrote in message
oups.com
I'm using Access 2002 on Windows 2000. I have a search form where the
user selects a row in the subform data sheet and then clicks an open
button to bring up another form with the data related to the row they
selected. The open button runs some simple code that does a form open
based on the primary key field in the subform. In testing, our QA
inadvertently clicked multiple times on the open button and ended
creating 10 plus instances of the form (I didn't think this was
possible in Access) and if you try to click on one of the instances
Access crashes.


That shouldn't be possible using "simple code", though it is possible
using code that I would consider "advanced". What is the code behind
the button?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)