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

  • Thread starter Thread starter Jason Buck
  • Start date Start date
J

Jason Buck

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
 
If
the user did update/insert data I want to prompt the user
to save.
Click to expand...

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
 
Back
Top