By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 1,979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

Detecting record change on a form

P: n/a
Is there a general method for detecting that a user has changed the
record currently visible on a form, whether this is by hitting PgUp or
PgDn or clicking on a navigation button, even if no change has been
made in any control?

I'm thinking of a situation in which a number of records have been
entered on a form and the user is cycling through them to check the
data entered. I want to be able to detect this and update certain
information record by record.

Mar 2 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi, Michael.
Is there a general method for detecting that a user has changed the
record currently visible on a form, whether this is by hitting PgUp or
PgDn or clicking on a navigation button, even if no change has been
made in any control?
The form's OnCurrent event fires whenever the user moves to another record.
Place your code in the Form_Current( ) procedure in the form's module.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"wwwords" <mi*************@gmail.comwrote in message
news:11*********************@h3g2000cwc.googlegrou ps.com...
Is there a general method for detecting that a user has changed the
record currently visible on a form, whether this is by hitting PgUp or
PgDn or clicking on a navigation button, even if no change has been
made in any control?

I'm thinking of a situation in which a number of records have been
entered on a form and the user is cycling through them to check the
data entered. I want to be able to detect this and update certain
information record by record.

Mar 2 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.