Tricky Form Problem

[twoplustwo]

Hi guys,

I have a form bound to a table that records actions.

For a given record I enter the date, date+1 and date+2 along with some details.

My structure, rather than record 3 dates in one record, is to add 3 records to the table for each date I am forecasting for. As far as I understand, this is normalised.

The problem I am having is that I create the first record with no problem. The issue is for the two records after at day ahead and D+2. I need my form to create two new records after the initial within-day data has been entered. I'd like this to be on the same screen if possible, and not have to use 3 records in a continuous form view.

Thanks for any advice offered!

 

[twoplustwo]

Attached is a JPEG of what I hope to achieve based on the left hand column of data.

 

[twoplustwo]

Guys,

I now have two subforms on the main form, one for D+1 and one for D+2.

At the moment they are just showing records from the first column of data which isn't quite right for a couple of fields, they are also not creating nwe records just displaying them.

Does anyone have any advice on how to tell the subforms to create two new records? Thanks/