PDA

View Full Version : Row Source repeating values

accessrookie2
08-07-2009, 09:41 AM
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
08-07-2009, 10:42 AM
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: http://downloads.btlarson.com/AWF/screenshots/sigma.png
accessrookie2
08-07-2009, 10:48 AM
Thank you - exactly what I needed!