Stop Making New Records After Last Payment in Amortization Schedule

[justdone]

I'm creating an amortization schedule that automatically recalculates whenever I put an amount at my Payment field. I have no issues with the computation but the problem is that it creates an infinite number of records with zero values after the last payment. How do I stop it from generating new records so that my last record is my last payment?

[CJ_London]

no idea without knowing what you are doing at the moment. Suggest copy/paste any vba code and/or sql you are using to the thread (not screenshots). Once pasted, highlight the pasted code and click the # button to preserve formatting

[CarlettoFed]

Maybe if you attach a sample file everything becomes easier.