Hi, I hope all of you are fine, I'm making some sort of Accounting System in Ms-Access, I have attached the screenshot which will help you what i want to do? I have 02 tables for my Accounting System, 01 is tblDebit and 02 is tblCredit with a relationship of 01 to many relationship, I've created a form named as Rent Deposit Form which contain tblDebit and tblCredit as subform, First of all I want Ms-Access to don't save record until the tblDebit.Amount = Sum([tblCredit.Amount]), I want to apply this check, My second requirement is that If a user enters alot of transaction data in this form and he don't want to exit the record without saving this added data, the undo command will not work, because it works on main form and in subform it have 5 transactions it could not undo this complete recordset, Please help me in this matter. Thank you
Hi
I suggest one simple way would be to create temp tables and link forms to those temp tables. and add the records to the data tables when conditions meet.
