Mainform fields fixed while subform datasheet can scroll (1 Viewer)

[boerbende]

Dear readers,

I have a simple datasheet subform in a mainform
in the datasheet I show multiple columns, in the mainform I show the totals for some of the columns.
For example

as in capture 1

The totals are located straight above the columns of the datasheet.
But if you move the cursor in the datasheet to the right, the columns go to the left, which makes that the totals not correspond to the columns

as in capture 2

If somebody knows a solution to avoid this happening, I would be happy to hear about that.

Many thanks

Ben de Boer

 

[sneuberg]

It's not clear from your post why the columns in the datasheet are moving. Your second example is the same as the first. Suggest posting some screen shots of the problem.

Just a guess but maybe putting the totals in the subform header would help.

 

[boerbende]

Thanks Sneuberg. This was not visible during editing, neither when I reopened the form. I changed it to two captures.

 

[sneuberg]

I'm not seeing the screen shots. Did you click the upload button?

 

[CJ_London]

why not just put the totals in the subform header?