Auto generate schedule within a form

[andibeans]

Is it possible to auto generate a payment schedule within a form based on a query? I have a form that has the usual customer name, address etc. I want to be able to generate a calculated schedule that shows the yearly amount due and interest payments for a number of years.

If I input the total principle $5601.80, 15 years at 7% interest rate and start date, it shows the below information.





I’ve done this in a query…but it was out of control. I had too many fields and a ton of expressions. Not to mention building the reports needed was a nightmare. I am not sure how to go about building this. Do I code it through VBA , build using macros, use lists/combo box, etc.

Any help or suggestions would be greatly appreciated. Thank you!

[ranman256]

ID say form boxes and queries via macros.