populate combo box from table

[bar891]

I'm trying to use a combobox as a filter for a search page. I want to populate the list in the combobox from a table but i have multiple entries that are the same. I only want one of each different entry in the combo box. what is the best way to filter this ?

[orange]

Use Select DISTINCT in the combo rowsource sql.

[bar891]

i tried that but it didn't work

[CJ_London]

'didn't work' doesn't help us to help you. What error did you get? or was it a wrong result? if so, what was wrong with it?

What is the sql to the rowsource you used that 'didn't work'?

[bar891]

This is what i used as the Row Source

SELECT DISTINCT tblProgramming.ID, tblProgramming.Make FROM tblProgramming ORDER BY tblProgramming.Make;

But it still shows me multiple entries of the same name.
When i take out tblProgramming.ID i then get a blank combobox

[CJ_London]

it will do because of the ID. you should have a separate table for Make and storing the ID in tblProgramming, not the description. - Then your rowsource would be based on the make table

If you haven't then the ID is irrelevant since it is not the ID of the make. The reason you are seeing a blank combo is because you have hidden the first column - this should be left blank or have a value greater than the width of the combo control - and your column count should be 1, not 2

[bar891]

Thanks for your help.. I have it working now
I have made an extra table for Make