Opening Form in Alphabetical Order

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

flygal5 - 25 Mar 2008 14:52 GMT

I've forgotten what to do in order for my Form to open in Alpha order. Can
someone help? Thanks.

Reply to this Message

Douglas J. Steele - 25 Mar 2008 15:20 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> I've forgotten what to do in order for my Form to open in Alpha order. Can
> someone help? Thanks.

Reply to this Message

flygal5 - 25 Mar 2008 16:15 GMT

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?

> 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.
>
> > I've forgotten what to do in order for my Form to open in Alpha order. Can
> > someone help? Thanks.

Reply to this Message

Douglas J. Steele - 25 Mar 2008 16:31 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Thanks, Doug. But when you say "returns the data in alpha order", do you
> mean
[quoted text clipped - 8 lines]
>> > Can
>> > someone help? Thanks.

Reply to this Message