Problem subform in sheetview

[TNL]

Hi,
I have a subform (frmData) on a normal form (frmMain), this subform is
showed in sheet modus.
Normal, when I change format of the sheetview, such as the ordering of
columns (I drag a column to desired position), this form will know it and
the next time it will be shown as the last time.

But, when my program set the filter of the form, it will not show the
columns as last ordering. The code looks as following

dim sFilter as string
sFilter = ....
frmData.form.filter = sFilter
frmData.form.filterOn = true

Why? How can I do?

Thanks
TNL

 

[Alicia]

Changing the order of columns in the form view or query
view or table view can cause unexpected results. Always
change the order of the columns in design view, that way
it should always be the order that you choose.

 

[TNL]

The users change the order and they want, that my program can remember this
order.
As programmer we can not always know before, what the users want exactly. It
is good, that our program is enough flexible.

TNL