I use Access97, I bound the 1-side table to the form directly, and many-side table bounded to subform.
When I edit many records in the subform, say I edit 4 many-side table record, I can't undo all 4 record.
So I try to use BeginTran.....Commit,Rollback. But It doesn't work.???
I set the workspace varable MyWs to dbengine.workspace(0), is it ok? how I know (0) is the right one? ...Then I use MyWs.begintran..... to mimic data entry buffering, so I can undo all by rollback. But I fail.
Why????
Can I use openrecordset on CurrentDB to open table in VB code, instead of directly bound table to form? So I can use the power of DAO?
But there is no grid box control provided by Access97(is it? Can I deliver ActiveX grid box to user?), I forced to use subform.(I don't know how to map recordset object to a form, such as subform)
Eventually, I build the 1 to many data input form with no Cancel, only Save(User much responsible for any mistake he make, if he forget the previous data).
Can anyone teach me to solve it?Thanks.
-Jasper
oh, what is the fastest way to write good program?