Sorting an Access Runtime form

[BIGGY]

In Access it's very easy to sort a Tabular form by a column. However I don't believe that there's a sort button in Runtime. The MDB (soon to be MDE) is pretty basic. One table, and one form linking to that table...pretty basic. Any suggestions on sorting columns in the runtime version? My guess is to create buttons that run a macro or vb script to sort each column. Other ideas instead of this? Either one of my methods more recommended than the other?

 

[BLeslie88]

yes...

vba will be the way to go mate...

and beware if you find advanced controls for runtime... if you try to set up a user on < 2000 windows platform, the more advanced the components, higher probability it won't work.

Just a note... for yourself.

But test and try and enjoy.

 

[BIGGY]

Know any good links off the top of your head for vba code that'll do it? No doubt it's already been written for a function like this.

 

[BIGGY]

Found the code...pretty basic.

Me.OrderBy = "[Name]"
Me.OrderByOn = True