I have a main form which has the date (primary key) and quite a few sub forms on different pages. the one i am having trouble with has 6 sub forms all linked by the date.

I want a record to be recorded for each date regardless of data being present for that date or not.

I have tried code to change data on all the sub forms, add data, setting the focus on a control and all of them together as well to create the records without success. but if you manually click on a field, it creates the record.

I'm a little stuck =<


form is pretty bug, all the data needs to be there, one record for each sub form is saved per day, or at least that is how i want it.