Prev: When Access 2007 opens, open the default database file
Next: Access 2003 saves in 2000 by default.
From: John W. Vinson on 30 Mar 2010 18:01
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 31 Mar 2010 09:39
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 2 Apr 2010 02:42

"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]


First  |  Prev  | 
Pages: 1 2 3 4 5
Prev: When Access 2007 opens, open the default database file
Next: Access 2003 saves in 2000 by default.