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 Kennedy 51 days ago
Kevin Robertson 51 days 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 Kennedy 51 days ago
Thanks again Kevin
Kevin Robertson 51 days ago
You're welcome.
William Kennedy 50 days ago
So Easy!!! Thanks Kevin
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
