How to Copy a Recordset and test to see if changes were made

's Computer Specifications

w/ACCESS 2003

I am trying to copy a recordset once the form it loaded.
When the user exits I want to the VBA to check the Copy
and the Current RS to see if the user made changes. If
the user did update/insert data I want to prompt the user
to save.

I can't seem to figure out the syntax... Any body know
the syntax to preform this process.

Thanks in advance

's Computer Specifications

"Jason Buck" <(E-Mail Removed)> wrote in
news:026201c37ba6$058f4990$(E-Mail Removed):

> If
> the user did update/insert data I want to prompt the user
> to save.
>

Unless A2003 has made severe changes in the way it handles forms, then
surely the form saves everything everytime it moves from one record to
another anyway. Have you tried trapping the BeforeUpdate event?

Tim F

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using VS7.0 to test an SDK made on VS8.0	realrobby@gmail.com	Microsoft VC .NET	4	16th Jul 2007 03:55 PM
ADO test for empty recordset	=?Utf-8?B?QmlsbHlSb2dlcnM=?=	Microsoft Access VBA Modules	3	26th Sep 2006 04:50 PM
obtain recordset of an object COM made in VB6 and soon fill dataset	Yoel Mc Lennan	Microsoft Dot NET	0	27th Jan 2006 05:57 PM
Test for empty recordset?	=?Utf-8?B?Y3RkYWs=?=	Microsoft Access VBA Modules	4	6th Nov 2005 03:20 AM
Intermediate question: I want to create a log of all transactionsand who made them associated w/ a recordset.	Jeremy Hine	Microsoft Access Forms	1	8th Feb 2005 11:33 AM