event that capture On another record

Hi Gusy

what is the event that will capture  move to a different record, ex.
i am working in the current record(On Current), when i change to another record(Next, Last, First, jump to x record), what is the event that captures that

What is the difference between After Render, After FInal Render?
titorober23Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

titorober23Author Commented:
i seem comments about RecordExit Event but i do not see it in my properties, i am using Access 2007
0
mbizupCommented:
The Current Event fires when the form opens and when the user changes records.
0
mbizupCommented:
<RecordExit>

The Exit event is associated with individual controls, not the form.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

titorober23Author Commented:
i need to capture when user is jumping to another record, this is different that On Current event
0
mbizupCommented:
IF the user has edited data, you can use the Before or After update events, depending on your needs.

If you cannot guarantee that the user will edit data in the form, you would have to hid Access's navigation buttons, disable the mouse scroll wheel to prevent the user from scolling between records, and create your own record navigation buttons with custom code.

Anything that needs to happen before the user actually enters the new record should be included in the Click Events for these record navigation buttons.
0
titorober23Author Commented:
what about if a user is just browsing through records, or when change current record
0
mbizupCommented:
That is what I'm referring to...

The Current Event fires immediately after the user changes to a different record.

If you need code that fires immediately before the record changes (for example to prevent a user from completing a change to a different record), you need custom navigation buttons with custom code.

There is no event in an Access database that fires at this point.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mbizupCommented:
<when change current record>

If you mean data changes, the Before and After update events do this.

Again for browsing through records, the Current Event is the closest, but that happens after the user moves to a different record.
0
mbizupCommented:
titorober23,

Regardless of whether you 'liked' this answer, there is no other way to accomplish what you are trying to do.

I explained this in detail, and the answer deserved better than a 'B'.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.