I am convinced that the act of thinking logically cannot possibly be natural to the human mind. If it were, then... our species would not have taken several millennia to figure out the scientific method.
Using a Select record Combo to select a record from a table. I use a select record combo to select a record in a table in my form. I select last name but show in the combo box Last Name, Full name as we have members with common last name. When a new member is added to the database it shows up as the last record. Is there a way to pre-sort the Select record Combo values in an ascending way?
William KennedyOP
@Reply 2 years ago
Kevin Robertson
@Reply 2 years ago
Add an ORDER BY clause to the SQL in the Row Source of the Combo Box.
Example. SELECT CustomerID, LastName, FullName FROM CustomerListQ ORDER BY LastName;
William KennedyOP
@Reply 2 years ago
Thanks again Kevin
Kevin Robertson
@Reply 2 years ago
You're welcome.
William KennedyOP
@Reply 2 years ago
So Easy!!! Thanks Kevin
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
TechHelp.
The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
