Combo Box (Repeat Values)

[canjfn]

When dropping down my combo box the field that i'm utilising has many record sets (ie job No) so this means that the Job No is repeated may times. I would like to restrict the drop down list in my Combo Box just to list only one instance of each record.

Thank You In Advance for you help

 

[Rich]

Select Unique Values in the Combos underlying query

 

[canjfn]

The combo box is unbound

 

[namliam]

You must have something filling the combobox with those double values...

Probably a query...

BR

 

[shadow9449]

The combo box is unbound

Being unbound doesn't mean that it doesn't have a data source.

Check the query that serves as its data source, and you should be able to tell it to SELECT DISTINCT.