MS Access- How to create a list from a Combo Box

Patrick Snyder 0

On my form, I want a combo box that displays a list from my table that based on a select from the table, returns a list of matching records.

6 answers

Ken Sheridan 3,546 Reputation points

2025-12-06T14:22:49.5733333+00:00
My first reply failed to reproduce the SQL statement correctly, and can't be edited. The following is the corrected SQL statement:

SELECT LastName, 1 AS SortColum FROM Contacts UNION SELECT "All Names", 0 FROM Contacts ORDER BY SortColum, LastName;

It worked this time!
Please sign in to rate this answer.
Patrick Snyder 0 Reputation points

2025-12-08T16:53:49.85+00:00

Ken,

the form "Contacts" is close to what I would like to do, except that instead of entering any part of the persons last night, i want to be able to select from a Combobox. Once I select one of the materials, then the list populates with all of the records that matches what I have selected in the Combobox.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer