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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamically changing a subform's recordset using txt box 1
unbound form returns values to table 2
Jump to specific record in recordset 1
Validate recordset 2
Outlook Attachments via Recordset 3
MS Access setting outlook reminders from a DAO recordset 0
How do you set a recordset's bookmark? 5
How to test a query "if no results" then... 6

Back
Top