Subform events not firing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mitch Powell - 31 Oct 2007 16:37 GMT

I am using a main form (Level1) that has subform (Level2) which in turn has
another subform (Level3). Both subforms are being dsiplayed in Datasheet
view such that expanding a row on the Level2 subform Datasheet displays opens
up the Level3 subform to show child reocrds.

The problem I'm having is the events on the Level3 subform frequently do not
fire. Sometimes they do, sometimes they don't. I am not able to discern a
pattern. I have noticed that when I have more than one row expanded on the
Level2 subform, the events for one of the Level3 subform instances will fire,
but not for the other instance(s).

I'm at my wits end. Has anyone else dealt with the before?

Reply to this Message

Mitch Powell - 31 Oct 2007 16:58 GMT

Further to my post, is occurs to me that when a form and it's subform are
displayed in Datasheet view, there are multiple "instances" of the subform
(i.e. one for each parent record that is "expanded". It seems that part of
my problem has o do with the fact that some of those "instances" seem to have
stopped responded to events. I'm not sure how to conceptualize this
"multiple instance" thing. Why would events fire on some instances but not
others.

> I am using a main form (Level1) that has subform (Level2) which in turn has
> another subform (Level3). Both subforms are being dsiplayed in Datasheet
[quoted text clipped - 8 lines]
>
> I'm at my wits end. Has anyone else dealt with the before?

Reply to this Message