Force Combo Box to offer unique values from the table

[vazdajic]

Hello there..
How can I force my Combo to offer me only unique records from the source column in my data table ("Table1")?


Below, please find database in ZIP.



Thanks.

[orange]

In your view what exactly is a duplicate?

To get unique values you can use the DISTINCT parameter on your combo Row source.

Consider, John Smith from California, and John Smith from Idaho..... are these duplicates? If so, please explain.

[vazdajic]

Thanks for reply..

AS you can see on the picture I've posted, John Smith from California, and John Smith from Idaho are two different records.. As both of them are named the same, it makes no sense for me to see last name Smith twice. Anyway, after I choose Smith in 2nd combo, I am going to choose California at last (third) combo..

Imagine I have 35 Smiths and 5 other and mutually different last names (in total 40 records).. In that case I want second combo to offer me in total 6 rows (Smith + 5 other ones).

Hope I have made myself clear in what i would like to have here.

[orange]

The concept underlying what you are trying to achieve is called Cascading Combos.

Here are some links to more info on Cascading combos.

This pair is from DataPig. A little older but excellent example.
http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html

From Paul http://www.baldyweb.com/CascadingCombo.htm

You can google/youtube for more info.
Good luck.

[ArviLaanemets]

Are combos at right to select person in form? In this case you'll be better of with a single combo!

Create any record selection combo, p.e. cbbSelectPerson, and then edit it:
Set RowSourceType property = 'Table/Query';
Set RowSource property = 'SELECT tblPersons.ID, tblPersons.First_Name & " " & tblPersons.Last_Name & " (" & tblPersons.City & ")" AS PersonInfo ORDER BY 2';
Set BoundColumn property = 1
Set ColumnCount property = 2
Set ColumnWidths property = '0;2.5'

In form's OnCurrect event, set
Me.cbbSelectPerson = Me.[ID]

The combo displays selections like
"John Malkovich (Boston)"
"John Malkovich (Orlando)"

and when combos events are set properly, selecting a row in combo displays selected person's info in form (and moving to another record updates the combo too).

[Missinglinq]

To get unique values you can use the DISTINCT parameter on your combo Row source.

Like this:

SELECT DISTINCT [Table1].[Last_Name] FROM Table1 WHERE (([Table1].[First_Name])=[Forms]![frm_Main]![cbo_First_Name]) ORDER BY [Table1].[Last_Name];

Linq ;0)>

[vazdajic]

Huge thanks! This is what I have been looking for! This works perfectly!

[Missinglinq]

Glad we could help!

Linq ;0)>