Sorting data in Access

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Dragn73

Thread Starter
Joined
May 23, 2002
Messages
29
I have a table named Contacts with a First and last Name field and then a combo box on a form named issues that uses a drop down to select one of these contacts. I also have an Add button next that pulls up the Contacts form and allows for someone to add a new contact name to the table and thus adding it to the drop down for next time. I am trying to get that to sort by Last Name then First name and I am not having much luck. Any help would be appreciated.

Thanks
 
Joined
Jul 29, 2001
Messages
21,334
Set the Oder By property for the dropdown to Last name, first name
 

Dragn73

Thread Starter
Joined
May 23, 2002
Messages
29
And where do i find that order by property for the drop down? I looked the property list and didn't see it or am i looking in the wrong spot?

Thanks
 

OBP

Joined
Mar 8, 2005
Messages
19,895
Personally I prefer to base the Combo Box on a Query and do the sorting in the Query.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

No members online now.
Top