Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old December 21st, 2004, 10:37 AM
Authorized User
Join Date: Aug 2004
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default Form change record event ??

Hi All,

Another maybe stupid one,...

Is it possible to trap the form event when the user moves from one record to another (or create a new one )?

The database I'm working on, must be working with both office versions XP/2003


Old December 21st, 2004, 12:21 PM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts


   Does this article help on creating a macro to trap the date a record was last modified? I am not sure why you want to trap movement between records other than to trap updates to records.


I know there is code to do this and that you can trap the username as well.



Similar Threads
Thread Thread Starter Forum Replies Last Post
Change of event using 2 combobox yogeshyl Excel VBA 0 July 31st, 2007 05:02 AM
Event on record change needelp Access VBA 5 October 18th, 2006 07:13 PM
Change Event Help BryanBrassell Excel VBA 4 July 29th, 2004 03:42 PM
Change Event BryanBrassell Excel VBA 0 December 18th, 2003 01:27 PM
Help with Worksheet Change Event BryanBrassell Excel VBA 1 June 24th, 2003 09:08 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.