How to Undo Subform ?

[edisonl via AccessMonster.com]

Hi,

1. I have a subform where captured all pass transations history, in addition
there is a field (checkbox) allowing user to check to reprint particular
record. all this works fine and the reprint record is inserted into
TransactionHistory_subform

2. However, when user amend certain field, Remarks Column, I like to keep
original record's Remarks as of origin (might be empty)

3. Therefore I tried to do

recordcount = TransactionHistory_subform.form.recordset.recordcount
for a =1 to recordcount
TransactionHistory_subform.setfocus
TransactionHistory_subform!Remarks.undo
TransactionHistory_subform.Form.undo
DoCmd.GoToRecord , , acNext
next a

But apprently the undo command doesn't works..

Anyone knows how to work around this ?

Regards, Edison

 

[Larry Linson]

I am not certain exactly what you intend to Undo. As best I can guess, you
are not properly addressing anything on the Form embedded in the Subform
Control. If you were, you aren't doing anything to move from record to
record, so you would be undoing the same value over and over, which is
probably not what you want to do. And, if you were moving from record to
record, it still wouldn't undo anything, because Undo only reverses actions
that have not yet been saved. Perhaps if you could clarify what it is you
are trying to accomplish, someone might be able to make a useful suggestion.

Larry Linson
Microsoft Office Access MVP