Working in a memory Space??

[Superock]

I have been asked to add a button to a form that will be an "Update" button or add the functionality to the form that when a change to the record (On the form) or any data on the subs has been made that the user is prompted to either except the change or not.

The form I am using has multipule subforms and is also tabbed.

As I am new to this I would expect that this is not possible(Working inside a memory block and then only aply changes to the record once you are done)

I did suggest that we create a Undo button but it seems this is to prevent changes that have been made unknowingly.

 

[RV]

Look up the method Dirty in Access Help, I guess you could use this method to determine whether a record is 'bout to be changed or not.

RV

 

[modest]

since there have been two posts saying to do this already, i'll add to it:

Lookup the Dirty event in the help file or on msdn (or even this site).

 

[Rich]

Or you could just use the Before Update event without the Dirty property