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
 
You must log in or register to reply here.

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

How to Navigate Through Records in Alphabetical Order 2
Order of records on a forn 3
Open Multiple Microsoft Office Documents in Alphabetical Order from Windows Explorer. 0
Alphabetical order in combo box 7
put dropdown list in alphabetical order 2
Alphabetizing drop down list? 0
Query won't alpha Combo Box 6
Contacts in Alphabetical order 2

Back
Top