"Order By" not working!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several forms (6 to be exact) where i need them sorted by a certain
field within each for...so I went to the form's properties, click on the
"ALL" tab, and in the ORDER BY field, i enter the name of the field i'd like
it sorted by, and then i check the results.....It doesn't work for all but 2
forms!!! Why is this???
 
never mind....found a similar question here....i went to the Form in "Form
View", right clicked on an empty spot, and clicked "Apply Sort/ Filter" and
that did the job

Hope this will help others who are having the same problems
 
Or you can set OrderByOn = True in VBA code in one of the Form
initialisation events.

never mind....found a similar question here....i went to the Form in "Form
View", right clicked on an empty spot, and clicked "Apply Sort/ Filter" and
that did the job

Hope this will help others who are having the same problems
Click to expand...

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Back
Top