Displaying only unique values

[MCCDOM]

Hi all,



I am trying to create a combobox that acts as an auto-complete box to speed up the form filling in process. The combobox is getting the results from a column in a table but is showing everything including the duplicates when I only want to view a list of individual names. I've done some research and have come accross SELECT DISTINCTROW but am unsure on how to implement this for a combobox or if this is the best method for going about this.
Would really appreciate some help.

Thanks

Dom

[ranman256]

In the query of the combo box, open the properties, set UNIQUE VALUES = YES.

[MCCDOM]

Thanks for your reply. You must excuse my basic knowledge of Access but where can I find this? The combobox is in a form and is setup after using the wizard to retrieve data from the specified column in a table.

[thebigthing313]

Select the combobox control, go to it's Property Sheet, then go to RowSource (in the Data tab). Click the "..." button to open the query builder. In the query builder, open the property sheet (if not already) then you will see a property called "Unique Values". Set property to Yes.

[MCCDOM]

Thanks, I have done this but the combobox only shows three blank rows.

[thebigthing313]

Go back to the query builder of the Row Source, and view the query as a Datasheet and see if you are seeing what you expect.

If so, make sure your combobox's properties for ColumnCount and ColumnWidths (under Format) match the query.

[June7]

Instead of DISTINCTROW, try just DISTINCT.

[MCCDOM]

I changed the column width and they are now being displayed. Thanks a lot everyone for your help.

[thebigthing313]

Good luck with the rest of your project.