For your enhanced continues split form, why do you need a subform? I can create a continuous form and copy and paste the exact controls to the header. It behaves like a split form. I can add, delete & edit a record both from the single and continues section.
Yes you can simulate a split form with e.g. a single form in the header and a continuous form below. The advantage is it needs no code to stay in sync. A minor disadvantage is the record highlighter feature covers the first row if the columns are sorted by the header. Replacing with a record selector solves that.
I just wanted to report back we had to change our path.
As I suggested above, we used an enhanced split form without subform. We made a continuous form and added the exact fields as controls in the header of the form. It gave us an split form without having a subform.
Working with this form was much easy, because it was a continuous form in a single form. Referencing controls, moving between records, codes were shorter. It was much easier to work in a single form than having a subform. Very fast and easy to use.
There was a major problem that we couldn't solve. When the count of shown records in continouse form was more than a page, we couldn't scroll the form with mouse wheel. We had to grab the vertical scroll bar and drag it up and down to see previous or later records. this, in turn caused a lot of flickering that we couldn't solve.
We are now following
@isladogs and
@GPGeorge advice and using a sub form in a single form to enhance a split form. It's much stable and mouse wheel works just fine in the subform, plus no flickering when moving between records in continuous form.
Not that I doubted your knowledge and experience, but sometimes one need to feel the problem to understand it.
We really appreciate all given advices on split forms specially those given by
@isladogs,
@GPGeorge &
@Galaxiom .
