Reordering entries in form

[Neil Greenough]

I have a form with a few entries running in it, 1-10. Now, what I would like
if possible, is for the entries to be reorganised so that they are listed
alphabetically. So, when I open the form, instead of getting entry number
one, I get the entry beginning with A.

I have resorted the columns in my table, however this ain't helped.

[Simon Hayes]

"Neil Greenough" <ne***********@btopenworld.com> wrote in message
news:ck**********@hercules.btinternet.com...

I have a form with a few entries running in it, 1-10. Now, what I would
like
if possible, is for the entries to be reorganised so that they are listed
alphabetically. So, when I open the form, instead of getting entry number
one, I get the entry beginning with A.

I have resorted the columns in my table, however this ain't helped.

Is this another Access question? :-)

In MSSQL, you could order the data with an ORDER BY when you retrieve it
from the database:

select col1, col2, col3
from table1
order by col2

I have no idea how you would do it in an Access form, though. You might want
to try in microsoft.public.access.forms.

Simon