Form will not Sort

[Shift838]

I have a form I input server information on. I have a text filed called txtservername. My table it stores all information in is tblServers. I want the form to sort the servernames in ascending order. I changed the orderby in the form to tblServers.txtServerName and it still will not sort.

 

[Remou]

You need the name of the field, not the name of the control. You probably need to set OrderByOn to True, as well.

 

[Nickaroo]

First make the table into a query and sort the query by txtservername. Second use the query instead of the table in the form. Besides, queries run much faster.