Opening Form in Alphabetical Order

  • Thread starter Thread starter flygal5
  • Start date Start date
F

flygal5

I've forgotten what to do in order for my Form to open in Alpha order. Can
someone help? Thanks.
 
Create a query on the table that returns the data in alphabetic order and
use the query as the form's RecordSource instead of just using the table.
 
Thanks, Doug. But when you say "returns the data in alpha order", do you mean
sort the query and save it? That's what I did and it still shows the form
data in random order. Unless I'm mistaken, there was something I did in
Properties of the Field or Form. Any thoughts?
 
When you create a query, you have the option of specifying a sort order (in
the graphical query builder, you do this by setting the entry in the "Sort"
row under a particular field (or fields) to Ascending or Descending. Once
you say that query, it will always sort the data when run.

The SQL of the query will look like:

SELECT Field1, Field2, Field3
FROM Table
ORDER BY Field1
 
Back
Top