Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Order by doesn't work
- Thread starter Smarty
- Start date
Smarty,
Ensure that your OrderByOn property has been set to True on the form, otherwise your sort will not take effect, even if the string has been populated. Also, in some instances, I've had to use the tablename.field name ASC format to effect an orderby clause. I generally call a routine on Form_Open that sets the OrderBy= & OrderbyOn= properties.
lldevel
Ensure that your OrderByOn property has been set to True on the form, otherwise your sort will not take effect, even if the string has been populated. Also, in some instances, I've had to use the tablename.field name ASC format to effect an orderby clause. I generally call a routine on Form_Open that sets the OrderBy= & OrderbyOn= properties.
lldevel
- Status
Similar threads
- Locked
- Question
