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.