I have a form with 3 subforms in it. The order by needs to be X_Id DESC, but he keeps it displaying (continious form) by X_Id ASC... In other forms with subforms it works fine, but in my mainform it doesn't ... Anyone familiar with this problem??
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.