"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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting criteria will not work with new records 1
Allowing Temporary Sorting 1
Order By question 6
Form won't keep its sort order 3
Split Form Not Honoring Select Statement 1
Order By not working when record source set by vba 3
Order By Property 4
Order By/Filter clause corrupted with aliases 6

Back
Top