List box help

[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.

 

[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.

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.

 

[Jeff L]

Yes, the RowSource for the List Box should be

Select Distinct YourFieldName

From YourTableName

Hope that helps!