This code will teach you on how to populate the subform using the criteria on the parent form with a click of a mouse. It will automatically compute the interest rate of a particular loan based on the number of term specified.

Good for beginners to learn Microsoft Access database programming.