2 small Questions

How do you put more than one code in an event
Ie.
on current
=LockBoundControls([Form],True)
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11353-2-small-questions.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11353
=AutoFillNewRecord(Forms!OrdersWDetails)

----------
2nd question:

How do I update the parent (Orders) lastedited field when I save the changes
in the child OrderDetails.

me.lastedited = Now

works for the Orders but not for the child...

Thanks!

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Answer 1:
You create an event procedure for your event and call the functions from
there:

Private Sub Form_Current()
Call LockBoundControls( Me, True )
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11353
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11353
Call AutoFillNewRecord( Forms!OrdersWDetails )
End Sub

Answer 2:
Assuming OrderDetails is bound to a subform on your Orders form:

Me.Parent!LastEdited = Now

The Parent property of a subform is a reference to the form which contains
that subform.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

"lmv" wrote in message
news:0E1D3A30-8A9C-4883-913F-368DD3FAE2F1@microsoft.com...
> How do you put more than one code in an event
> Ie.
> on current
> =LockBoundControls([Form],True)
> =AutoFillNewRecord(Forms!OrdersWDetails)
>
> ----------
> 2nd question:
>
> How do I update the parent (Orders) lastedited field when I save the
> changes
> in the child OrderDetails.
>
> me.lastedited = Now
>
> works for the Orders but not for the child...
>
> Thanks!

On Tue, 13 Jun 2006 1202 -0700, lmv
wrote:

>How do you put more than one code in an event
>Ie.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11353
>on current
> =LockBoundControls([Form],True)
>=AutoFillNewRecord(Forms!OrdersWDetails)

The event should show [Event Procedure], and you should edit the VBA
code to

Private Sub ()
Call LockBoundControls(Me, True)
Call AutoFillNewRecord(Forms!OrderWDetails)
End Sub

>----------
>2nd question:
>
>How do I update the parent (Orders) lastedited field when I save the changes
>in the child OrderDetails.
>
>me.lastedited = Now
>
>works for the Orders but not for the child...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11353

Use the AfterUpdate event on the subform and use

Parent!lastedited = Now

John W. Vinson[MVP]

THANKS A BUNCH!

"John Vinson" wrote:

> On Tue, 13 Jun 2006 1202 -0700, lmv
> wrote:
>
> >How do you put more than one code in an event
> >Ie.
> >on current
> > =LockBoundControls([Form],True)
> >=AutoFillNewRecord(Forms!OrdersWDetails)
>
> The event should show [Event Procedure], and you should edit the VBA
> code to
>
> Private Sub ()
> Call LockBoundControls(Me, True)
> Call AutoFillNewRecord(Forms!OrderWDetails)
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11353
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11353
> End Sub
>
> >----------
> >2nd question:
> >
> >How do I update the parent (Orders) lastedited field when I save the changes
> >in the child OrderDetails.
> >
> >me.lastedited = Now
> >
> >works for the Orders but not for the child...
>
> Use the AfterUpdate event on the subform and use
>
> Parent!lastedited = Now
>
> John W. Vinson[MVP]
>