I am trying to create a form with a subform for a schedule of payments.

I do not want to use Excel, Yes it works well in Excel BUT Access is better for my needs. :-)

All the calculations on the main form are done and working What I need to do is

For x = 1 to [Number of Payments]
Create Date based on Payment Number (the formula I came up with for this works in Excel)
and then add the Date field and [Payment Amount] field to the SubForm
Next X

Is this something that can be done without storing the information in a table until The end user approves the schedule from the main form?



-Dan