Solved

Event triggered on next record

Posted on 2013-11-27
5
545 Views
Last Modified: 2013-11-27
What events are triggered when going to another record under the same form?  I need to capture some fields when a record is opened.  The first record is easy.  I can get that in the form open event.  I think I can get the next one with the after update if a field has been changed.  I need to have a way a capturing the data if no fields are changed.  Actually that method would work for after update too.  So is there an event for going from one record to the next?

Thanks,
Ric
0
Comment
Question by:Joppa
  • 2
  • 2
5 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 39680832
the On Current event is triggered when you move from record to record without changing anything
0
 
LVL 57
ID: 39680837
BeforeUpdate, AfterUpdate, and AfterInsert if your leaving a record that is dirty (changed), and OnCurrent when a record gets the focus.

You'll probably want to use OnCurrent.

Just be aware that OnCurrent may fire multiple times for the same record.

Jim.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39680875
@jim
<Just be aware that OnCurrent may fire multiple times for the same record.>

i don't think so..

On Current fires only when the focus moves from one record to another.
0
 

Author Closing Comment

by:Joppa
ID: 39680920
Works great....thanks
0
 
LVL 57
ID: 39681085
<<@jim
<Just be aware that OnCurrent may fire multiple times for the same record.>

i don't think so..

On Current fires only when the focus moves from one record to another. >>

 That's not the case.  It also will fire if a form is refreshed or required.  When that happens, the focus doesn't move, but the OnCurrent will fire.  Try applying a filter/sort, note the record your on, then remove it and see what happens<g>.  Or just to a Me.Refresh.  OnCurrent will fire.

 As a result, depending on what your doing, you may need to protect your code from getting into an infinite loop by setting a flag.

Jim.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question