From: John W. Vinson on
On Tue, 30 Mar 2010 12:13:01 -0700, TL <TL(a)discussions.microsoft.com> wrote:

>Am I wrong to assume that 2nd form (LOTOFrmADD) that I open from the 1st
>Form (EquipmentFrm) is not truely a subform but rather just another form -
>could this be the isse?

It is in fact not a subform and does not have a Parent property. That's what
had us barking up the wrong tree!

Is LOTOFrmAdd in fact still open? or is it closed in the code that launches
EquipmentFrm? Perhaps you could post your actual code, and a description of
the *actual* situation.
--

John W. Vinson [MVP]
From: TL on
Yes - Once the EquipmentFrm is opened there is a command button to open the
LOTOADDFrm on top of the EquipmentFrm. The EquipmentFrm remains open behind
the LOTTOADDFrm until data is entered into the LOTOADDFrm and then is closed
via a command button on the LOTOADDFrm to again reveal the EquipmentFrm.

EquipmentFrm - Only code is to Maximize form on Activate and a command
button crated via Access toolbox to open LOTOADDFrm

LOTOADDFrm - Only code is command button created via the Access toolbox to
close LOTOADDFrm

"John W. Vinson" wrote:

> On Tue, 30 Mar 2010 12:13:01 -0700, TL <TL(a)discussions.microsoft.com> wrote:
>
> >Am I wrong to assume that 2nd form (LOTOFrmADD) that I open from the 1st
> >Form (EquipmentFrm) is not truely a subform but rather just another form -
> >could this be the isse?
>
> It is in fact not a subform and does not have a Parent property. That's what
> had us barking up the wrong tree!
>
> Is LOTOFrmAdd in fact still open? or is it closed in the code that launches
> EquipmentFrm? Perhaps you could post your actual code, and a description of
> the *actual* situation.
> --
>
> John W. Vinson [MVP]
> .
>
From: Risse on

"John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> kirjoitti
viestiss´┐Ż:6ud4r55kd8l34rcp1ogts5fc681jj7em52(a)4ax.com...
> On Thu, 25 Mar 2010 04:43:02 -0700, TL <TL(a)discussions.microsoft.com>
> wrote:
>
>>LOTOTable (LOTOGroups field) -> LOTOFrmADD (subform) - which has the
>>LOTOGroups field with the On Update code of the form set to
>>"Me.Parent!LOTOGroup.Requery"
>
> Odd. Try
>
> Forms!EquipmentFrm!LOTOGroup.Requery
> --
>
> John W. Vinson [MVP]