Display field items only once in combo box

[vector39]

Hi everyone,

Just curious, how can I display items in a field in a combo box only once? I tried doing, Lookup Wizard > I want the lookup field to get the values from another table or query > tblName > fieldName (ascending)

But what I see is:
N/A
N/A
N/A
Community
Community
MULTI
Clinical
Clinical
Clincal
...you get the idea

There's 18 items in this field, how do I display each item only once in the combo box?

[ranman256]

set the query property of the combo to UNIQUE VALUES = TRUE

[pbaldy]

Try a row source of

SELECT DISTINCT FieldName FROM TableName

using your actual table and field names.

[vector39]

Thank you!