I am a self taught beginner who is just beginning to try to understand writing modules in code – but I am struggling with the following;
I have a table, ‘Transactions’ which contains the fields [AccountNo],[Date],[Receipts],[Payments],[Balance] and a form ‘Input_Transactions’ to input the data.
I am trying to write an Event Procedure which, in effect, says – for the account number entered on the form- get the last balance from the table (ie from previous transactions) – add the receipts, subtract the payments – and store the answer in the field [Balance]
I have tried for some considerable time to do this but my limited knowledge is clearly not up to the job! Can anybody help please??