Form - alphabetical

I am a new user to Access and have created a mailing list for our office.
However, as users type in new addresses, they are not alphabetical. I would
like to put something at the bottom of the form so that I can click "A" and
be to the A names when I am searching for a specific person - or have the
form display the names alphabetical and not in chronological order of the
ID#.

Is this possible? And if so, how do I do it or can you direct me to the
language I need to look up in the help menu. Thank you.

There are several templates on the microsoft website that already do this.
No need to reinvent the wheel, just use one of those and modify it to meet
your needs. I think the "contact management" one is good.

If you don't want to do that, you can determine the sort order of the
records in your forms. You should not be sorting by the order in which they
are entered, you should be sorting by the name. Change the sort in your
form's data source.

--
Rick B



"jlw" wrote in message
...
I am a new user to Access and have created a mailing list for our office.
However, as users type in new addresses, they are not alphabetical. I
would
like to put something at the bottom of the form so that I can click "A"
and
be to the A names when I am searching for a specific person - or have the
form display the names alphabetical and not in chronological order of the
ID#.

Is this possible? And if so, how do I do it or can you direct me to the
language I need to look up in the help menu. Thank you.

Thanks - so simple. Is there a way to have basically the alphabet in the
form so that when I click on "D" it automatically goes to the D names? Would
I need to build a macro?

"Rick B" wrote:

There are several templates on the microsoft website that already do this.
No need to reinvent the wheel, just use one of those and modify it to meet
your needs. I think the "contact management" one is good.

If you don't want to do that, you can determine the sort order of the
records in your forms. You should not be sorting by the order in which they
are entered, you should be sorting by the name. Change the sort in your
form's data source.

--
Rick B



"jlw" wrote in message
...
I am a new user to Access and have created a mailing list for our office.
However, as users type in new addresses, they are not alphabetical. I
would
like to put something at the bottom of the form so that I can click "A"
and
be to the A names when I am searching for a specific person - or have the
form display the names alphabetical and not in chronological order of the
ID#.

Is this possible? And if so, how do I do it or can you direct me to the
language I need to look up in the help menu. Thank you.

I'm pretty sure the contact management database has that in one of the forms.

I know for a fact that the Northwinds database that comes with Access has this in the "Customer Phone List" form. it may also be in some of the other templates.




--
Rick B



"jlw" wrote in message ...
Thanks - so simple. Is there a way to have basically the alphabet in the
form so that when I click on "D" it automatically goes to the D names? Would
I need to build a macro?

"Rick B" wrote:

There are several templates on the microsoft website that already do this.
No need to reinvent the wheel, just use one of those and modify it to meet
your needs. I think the "contact management" one is good.

If you don't want to do that, you can determine the sort order of the
records in your forms. You should not be sorting by the order in which they
are entered, you should be sorting by the name. Change the sort in your
form's data source.

--
Rick B



"jlw" wrote in message
...
I am a new user to Access and have created a mailing list for our office.
However, as users type in new addresses, they are not alphabetical. I
would
like to put something at the bottom of the form so that I can click "A"
and
be to the A names when I am searching for a specific person - or have the
form display the names alphabetical and not in chronological order of the
ID#.

Is this possible? And if so, how do I do it or can you direct me to the
language I need to look up in the help menu. Thank you.