Same subform OK in more than one main form

  • Thread starter Thread starter Bradley C. Hammerstrom
  • Start date Start date
B

Bradley C. Hammerstrom

Access2000

I'm having a problem with three nearly identical forms. The first one I
created works just fine. It has a subform and the subform has a subform.
Then I copied it to make the two other versions of the form. The three main
forms are based on different queries, but share the same subform (and
sub-subform). At times the user may have all three forms open at once,
editing records in the subform and sub-subform.

At most, two users may be using the db at same time, but so far only I have
been testing it.

Q: Is there something inherently wrong with sharing subforms for data entry?

The problem: The two copied forms seem to suffer from *hanging* code. I
can't close the forms, and I can't change views. I get an error about code
running and advice to stop debugging, which I am not.

What do you think?

Brad H.
 
You can certainly use the same sub-form over and over. They are objects, and
like all forms do allow multiple instances of the same form. You can even
have 30 sub-forms on one form (and they are all the same sub-form). I did
this for a calendar. In fact, each sub-form code can still have its own
variables etc, and they are separate from each other sub-form (this is
despite the fact that they are the same sub-form). So, a new instating is
generated in memory for each one, and they DO NOT disturb each other.

The issues of junk code and other things laying out is of course a separate
issue
 
Back
Top