My attempt
here is what I have tried. What I am shooting for, is to have a loop that will open the payment sub form the number of times that the user chooses on the main form. This would then create a separate line item on the individual payment table that will be tied to the main table by...
I attempted the loop and was having issues. This is the first time I have ever attempted loop procedures. I was trying to get it to load the form x amount of times as the user inputed the amounts. I am postponing the work on this issue to finish the rest of the dB. When I get back to that...
What the db will do is track payments in a payment plan. The user would put the number of payments to customize their customers payment plans....If the user sets up 4 payments, I want them to be able to schedule 4 payments populating the amount of the payment and the scheduled receipt date...
I have a form with PPL_ID, cust_name, and PPL_date, and numb_of_p. I would like to have the user enter a number in numb_of_p and when a button was clicked, form ppl would open they would enter information on the form the data would update the table, close, and repeat the number of times entered...