[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 253
  • Last Modified:

how can i exit a record without saving any changes? *access 2003*

sofar i have a form bound to a table. when users navigate to a record they may need to make changes. if by accident they make changes and want to disregard them they need a way for the form to ignore any changes made. can someone please help and tell me what i can do to ensure this happens before the changes are writen to the records table?

thanks.
0
RiCHQRD
Asked:
RiCHQRD
1 Solution
 
peter57rCommented:
Hi RiCHQRD,
Different options are available.

The simplest is to put an Undo button on the form.
Alternatively, you can add code to the Form Beforeupdate event procedure to display a 'Confirm Changes?' msgbox.

if msgbox("Confirm you wish to save changes", vbYesNo,"Save Changes") = vbyes then
' do nothing
else
cancel = true
me.undo
end if

Pete
0
 
MikeTooleCommented:
Teach them to hit the Escape Key?
0
 
RiCHQRDAuthor Commented:
thanks peter.

that will do for now. i had the undo button but i was worried about changes they werent aware of so the code helped. my next task is to have a form open to register the changes in a revision history table, prefrably in another database. lets see how i get on with that.

Rich
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now