update undo query

[tina]

Hi
I have a database with an update query which works fine . My problem is if
user changes mind about whether to update and selects no it still updates.
The messages I get are
you are about to run an update query that will modify data in your table
have choice between yes or no
if select yes
a 2nd message appears
you are about to update X row(s) (where x is variable number)
once you click yes you can't use undo command to reverse the changes. Are
you sure you want to update these records
yes or no
at this point if you choose no records are still updated and undo is
unavailable
is there are setting I need to change
Thank You
Tina

 

[Allen Browne]

1. Open the query in design view.

2. Open the Properties view.

3. Looking at the properties of the query (not of a field), set the Use
Transaction property to Yes.