sorting data on a form

  • Thread starter Thread starter Jerry Crosby
  • Start date Start date
J

Jerry Crosby

I have a simple form with seven fields, based directly on a simple table
with seven fields. When the form is opened, I'd like the records displayed
in alpha order on the field [LastName]. I've typed "LastName" and
"[LastName]" (without quotes) in the order by property, but it doesn't do
anything.

What am I missing here?

Jerry
 
Easily done, I guess. Currently I have the source as the table, since I'm
using all 7 fields. Is it more efficient to use a query as the record
source rather than a table in that situation?

Jerry
 
Also, if you don't want a stored query that users can modify, you can set
the source of the form to the select statement directly, such as SELECT *
FROM yourTable ORDER BY LastName

Duane Hookom said:
Why not set the order in the form's record source query?

--
Duane Hookom
MS Access MVP


Jerry Crosby said:
I have a simple form with seven fields, based directly on a simple table
with seven fields. When the form is opened, I'd like the records
displayed in alpha order on the field [LastName]. I've typed "LastName"
and "[LastName]" (without quotes) in the order by property, but it doesn't
do anything.

What am I missing here?

Jerry
Click to expand...
Click to expand...
 
Back
Top