save or unsave changes in reord

[rudwan]

who do i code select save or unsave record changes while
user typing ?
what will be the code , and which event on the form (
after update event will apply also when new record
inserted )

 

[Wayne Morgan]

In the BeforeUpdate event of the form, ask the user if they want to save
changes. Set

Cancel = True

if they don't want to save the changes. Next, if they also want to undo the
changes

Me.Undo

 

[rudwan]

thanks very much
i tried it , it working well , but it applied also after
insert new record , who i can adjust the code to be
applied only when changes saved record not new ?

 

[John Spencer (MVP)]

Test the NewRecord property of the form. If it is false, then ...