List box help

W

wesley.allen

Hello All. Happy Thanksgiving.

I have alist box that is looking up values from a table. This table
may have the same value listed more than once. Is there a way to have
my list box only list the value once, even if it appears more than once
in the table the list box is pulling the value from?

Thanks.
 
R

Rick Brandt

Hello All. Happy Thanksgiving.

I have alist box that is looking up values from a table. This table
may have the same value listed more than once. Is there a way to have
my list box only list the value once, even if it appears more than
once in the table the list box is pulling the value from?

Thanks.
Click to expand...

In the query that the ListBox is using for its RowSource open the property sheet
in design view and enter "Yes" for the Unique Values property. In SQL view this
would be the same as adding the DISTINCT keyword.
 
Top