If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to Undo Subform ?
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.recordco unt 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200910/1 |
#2
|
|||
|
|||
How to Undo Subform ?
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 "edisonl via AccessMonster.com" u47544@uwe wrote in message news:9e5991bc641c0@uwe... 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.recordco unt 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200910/1 |
Thread Tools | |
Display Modes | |
|
|