F
flygal5
I've forgotten what to do in order for my Form to open in Alpha order. Can
someone help? Thanks.
someone help? Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Douglas J. Steele
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.
use the query as the form's RecordSource instead of just using the table.
F
flygal5
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?
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?
D
Douglas J. Steele
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
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