Subform order fields

[fedum]

I would like to change the order in à subform. Dragging is not working. Everytime I open the form with the subform the field is back to his oud place. Freezing won't help. Is there à solution?

 

[dhookom]

change the order" of what? Records or columns? I believe the only way you can save the order of the columns is to set the order in design view.

Duane
Hook'D on Access
MS Access MVP

 

[fedum]

Order of the columns. And normaly hou van do this in the design bit this don't work. Maiby à code in Vba

 

[dhookom]

Depending on your Access version, there is an Access Option to "Enable Design Changes for tables in Datasheet (for this database)".


Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

How are ya fedum . . .

Are you [blue]saving[/blue] while in design view after you rearrange?

See Ya . . .

Be sure to see FAQ219-2884 Worthy Reading!
Also FAQ181-2886 Worthy Reading!

 

[fedum]

Access version 2010
Yes I save wenn I change!