Close Form without updating records

[harleyskater]

I have a form I am working on and I want the user to be able to cancel his record update with a prompt.

So far I have stopped every process I can think of that would update the record, except when the form is closed. I made vb code that resets the recordset to nothing before close and it still finds a way to update?

What is the best way to cancel a record update in a process that will close or refresh the form like it was just opened??

 

[pbaldy]

Look at the Undo Method in VBA (using the Before Update event of the form)

 

[KeithG]

You need to use a transaction. The when the users close the form you can choose to commit the updates or rollback/cancel the updates.

 

[harleyskater]

Hi transaction sounds great but what PB did for me was great. I had to play around with it alot because it was going through a button but its working great. I just needed a point in the right direction : )

You need to use a transaction. The when the users close the form you can choose to commit the updates or rollback/cancel the updates.

 

[KeithG]

Glad you got it workd out. There is always more than one way to skin a cat