Making a column ascending

[RonnieODIN]

Hi All,

I am trying to make a column in a tabled form ascending when a certain checkbox is checked. Is this possible to do in VBA?

Thanks
-Ronnie.

 

[vbaInet]

Have a look in the property sheet under the Data tab you will see a property called Order By, set that property by typing in the name of the field you wish to order by and test it out to ensure it works.

Once you have that working, translate that into code and the methods of the form you need are OrderBy and OrderByOn.

Otherwise, you can:

1. Set focus to the control the field is bound to
2. And use this code:

DoCmd.RunCommand acCmdSortAscending

 

[RonnieODIN]

Thanks a lot

 

[vbaInet]

No problem!