Re: Update All Rows on Continuous form Based on Selection in Footer

On Mar 31, 3:02=A0pm, "Stuart McCall" wrote:

Stuart,

> Ok, I've looked back through the thread and I'm not certain I have your
> model correct in my mind. Let's review: As I understand it you have one ma=
in
> form containing 6 subform controls, all of which contain the same form,
> showing different data, presumably (else why do it).
>
> Is that a correct summation?

Yes, that is correct.

While the Object name of the subform might be SFRM_Mine, the name I've
given it when I added it to the main form is what I'm after, e.g.
SFRM_Mine_Inst1, SFRM_Mine_Inst2, SFRM_Mine_Inst3, etc.

Thanks,

Patrick

Re: Update All Rows on Continuous form Based on Selection in Footer

"Patrick A" wrote in message
news:92c0ae24-617b-4d6e-867b-434df97972fb@d1g2000hsg.googleg roups.com...
On Mar 31, 3:02 pm, "Stuart McCall" wrote:

Stuart,

> Ok, I've looked back through the thread and I'm not certain I have your
> model correct in my mind. Let's review: As I understand it you have one
> main
> form containing 6 subform controls, all of which contain the same form,
> showing different data, presumably (else why do it).
>
> Is that a correct summation?

Yes, that is correct.

While the Object name of the subform might be SFRM_Mine, the name I've
given it when I added it to the main form is what I'm after, e.g.
SFRM_Mine_Inst1, SFRM_Mine_Inst2, SFRM_Mine_Inst3, etc.

Thanks,

Patrick

Well there's no such property of a form as 'instance name'. The only way
(AFAIK) to identify the instance is via the subform control's name. These
are enforced by Access to be unique of course. The code I gave, ie:

Me.Parent.Name

if run in your subform's class module, will give you the name of the subform
control that is currently 'active', which is hosting your form. There's your
instance name. You can then refer to it from say a module, like this:

Forms!MyMainFormName!SubformControlName

(add .Form to refer to the subform itself)