I believe I should begetting a "Do While with out Loop" error????
I have two tables
The first one, rs1 is the outer loop. The file contains schedules that are the parent record to the second table of transactions, rs2. The major keys on the schedules table is DdSchedId and MatterId (Which is a higher parent)
The transactions represent the payments and the fees charged to a schedule. Each transaction has a DdScedTransId, DdShedId and MatterId to help link the two together.
The idea is that for each valid schedule there should be valid transactions that need to be totalled (Like trans types 13 = Direct debit, 50 = Direct Credit, 20 = Manual Payment) that need to be deducted from the Overall debt. Transactions 30 = Dis Hon fee, 35 = Penalty Fee, 60 = Transaction Fee, are needed to be added to the overall debt. The Interest, 40 = Interest, is recalculated on a daily basis to todays date (the date the update is actioned) and added to the total debt.
Some of the code I haven't included.
My problem is that I keep getting a "Loop without DO" error on the 2nd last line of code shown, The rest of the code in this Private Sub is commented
Any help will be most welcomed
I have attached the code
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
I have two tables
The first one, rs1 is the outer loop. The file contains schedules that are the parent record to the second table of transactions, rs2. The major keys on the schedules table is DdSchedId and MatterId (Which is a higher parent)
The transactions represent the payments and the fees charged to a schedule. Each transaction has a DdScedTransId, DdShedId and MatterId to help link the two together.
The idea is that for each valid schedule there should be valid transactions that need to be totalled (Like trans types 13 = Direct debit, 50 = Direct Credit, 20 = Manual Payment) that need to be deducted from the Overall debt. Transactions 30 = Dis Hon fee, 35 = Penalty Fee, 60 = Transaction Fee, are needed to be added to the overall debt. The Interest, 40 = Interest, is recalculated on a daily basis to todays date (the date the update is actioned) and added to the total debt.
Some of the code I haven't included.
My problem is that I keep getting a "Loop without DO" error on the 2nd last line of code shown, The rest of the code in this Private Sub is commented
Any help will be most welcomed
I have attached the code
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------