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 20 months ago
Kevin Robertson 20 months 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 20 months ago
Thanks again Kevin
Kevin Robertson 20 months ago
You're welcome.
William KennedyOP 20 months 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.
