Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Event triggered on next record

Posted on 2013-11-27
5
Medium Priority
?
587 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 2000 total points
ID: 39680832
the On Current event is triggered when you move from record to record without changing anything
0
 
LVL 58
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 58
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

824 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