Table and dragable column

[DevAccess]

Hello

I have table which has several columns what I would like to do is I would like to have them drag and anywhere user wants but that should save to that order when user comes back.

I remember this was happening earlier but now they can drag but when they come again they see that order has been restored to the default one

How to make this work? I mean they should be able to save the order once they reorder them

Thanks

 

[CJ_London]

once they have changed to order of the columns, they need to save the table - but users should not be looking at tables anyway

 

[DevAccess]

once they have changed to order of the columns, they need to save the table - but users should not be looking at tables anyway

I see forms's Movable property is set to No but I can not change it Yes anyways it automatically sets to No even if I select Yes

I am using MS Access 2010.

 

[CJ_London]

that is to do with moving the form - only applies to popup/modal forms or if db is set for overlapping windows - it won't affect columns

 

[HiTechCoach]

Are you viewing a form in datasheet view?

Is the a front end that is compiled into a accde? If yes, then that is why they can save the changes. You can't save design changes like this in a compiled database.