Duplicate data in a combo box

[BradleyS]

Hi everybody, I have a little issue here!

One Column in my table has multiple entries of the same data

I have built a query called "QryForm" using the table column and added it to my form as a combo box called "CboForm"

But when I open the combo box it displays all the duplicate entries, is it possible to view only one of each entry in a combo box.

Note: I cannot alter the table. Which only leaves the Query, Form or code

 

[Fizzio]

Set the Unique Values to Yes in the query supplying the combo.

 

[missinglinq]

BradleyS,

I think this excerpt from Access Help covers your problem. Access really does have good help files.

"Prevent duplicate records in a query based on fields in the design grid. Open a query in Design view.

Select the query by clicking anywhere in query Design view outside the design grid and the field lists.

Click Properties on the toolbar to display the query's property sheet.

Set the UniqueValues property to Yes.
If the query's results include more than one field, the combination of values from all fields must be unique for a given record to be included in the results.

To view the query's results, click View on the toolbar.

Note: When the UniqueValues property is set to Yes, Microsoft Access automatically sets the UniqueRecords property to No."

Hope this helps.

The Missinglinq