Row Source repeating values

[accessrookie2]

Hello, I have a combo box that I want to list all the values of a column of a table in.

Some values in the column are the same, lets just say there are multiple "Company" values. My combo box then list many different instances of "Company".

How can I narrow it down so it only list "company" and other values that repeat once in the list box?

 

[boblarson]

Hello, I have a combo box that I want to list all the values of a column of a table in.

Some values in the column are the same, lets just say there are multiple "Company" values. My combo box then list many different instances of "Company".

How can I narrow it down so it only list "company" and other values that repeat once in the list box?

Use the grouping button:

 

[accessrookie2]

Thank you - exactly what I needed!