Liz-
If the user (or your code) hasn't "dirtied" the outer form, then the Update
events won't fire. If the outer form has a change and the focus gets moved
to a subform, the outer record gets saved automatically and the events fire.
Same happens in reverse - the subform is "dirty" and you move focus back out
to the outer form, the subform events fire.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Friday, May 10, 2013 12:13 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: RE: [MS_AccessPros] Re: form after update when subform is updated
You know... I don't know if I tested this right or not actually now.
Respectfully,
Liz Ravenwood
Programmer/Analyst
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Clive
Sent: Friday, May 10, 2013 9:48 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: form after update when subform is updated
Hi Liz,
I would not expect the main form AfterUpdate Event to be triggered.
To verify if that's right or not, you can put a Debug statement in the
EventHandler with a MsgBox or a Debug.Print statement.
But if you change some data in the Main Form from within the SubForm code
then that would cause a Main Form AfterUpdate Event.
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood
<liz_ravenwood@...> wrote:
>
> Pros,
>
> I should know this, but I don't. If someone goes in to a record, and
edits something in to the subform, does the main form after update event get
triggered?
>
> Respectfully,
> Liz Ravenwood
> Programmer/Analyst
> Super First Class Products
> B/E Aerospace
> O: 1.520.239.4808
> www.beaerospace.com<http://www.beaerospace.com>
>
> This email (and all attachments) is for the sole use of the intended
recipient(s) and may contain privileged and/or proprietary information. Any
unauthorized review, use, disclosure or distribution is prohibited. If you
are not the intended recipient, please contact the sender by reply e-mail
and destroy all copies of the original message.
>
>
> [Non-text portions of this message have been removed]
>
------------------------------------
Yahoo! Groups Links
This email (and all attachments) is for the sole use of the intended
recipient(s) and may contain privileged and/or proprietary information. Any
unauthorized review, use, disclosure or distribution is prohibited. If you
are not the intended recipient, please contact the sender by reply e-mail
and destroy all copies of the original message.
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar