How can I undo changes to records in subforms?

[pjustin1]

HI, let's say when I made some changes to the data display in the subform, later I decide not save the amendments.. how can I do it?

I try using "undo record" but cannot.. DoCmd.Close also can help..
the amended data is saved in any circumstances..

plse help... thanks
juzz

NB: I need to keep the subforms amendable.. so I didn't lock it..

 

[Rich]

http://www.access-programmers.co.uk/ubb/Forum4/HTML/007174.html

 

[ebartlett]

I had help on this question too. The answer I got was to use this command.

Me.Undo
DoCmd.Close

Try this and see if it works...

 

[pjustin1]

Hi.. thanks for the solutions but none can work well...

for the 1st solution, me got this error msg "You enter an invalid expression that has an invalid reference to the property Dirty. The property may not exist or may not applied to the object you specified."

for the 2nd solution, it still save the subforms...

thanks... is there any other ways....?
justin