Hide Duplicates values in a Combo Box

[Dante1980]

Hi Guys,

I have a problem. I'm trying to import values to a Combo List from a table:

Row Source = SELECT Tasks.Milestones FROM Tasks;

where Task is a table and Milestones a field of that table. In this field (Milestones) there are repeated values, but I'd like to hide those duplicates when I want to chose them from the Combo List. I don't know If it is clear, if not it's because I'm not an Expert of Access

Thanks a lot for your attention,

Ciao

 

[Vassago]

Row Source = SELECT distinct Tasks.Milestones FROM Tasks;

 

[AHMED KHALAF]

Thanks
I had the same problem before. and you resolved for me. so thanks

 

[unclefink]

I see this post is 4 years old; however, its exactly what i am looking for, I just need to clarify.

Do i add the above line into my existing row source command.

The row source is currently occupied with: SELECT Tenants.Name FROM Tenants INNER JOIN [Main Data] ON Tenants.Tenant_ID=[Main Data].[Tennant Requiring Work];

 

[unclefink]

Disregard, i read further and found that i was not reading enough and figured it out based on what you had posted. Thanks for the great information.