Duplication of data in combo box - table source 1

[WeekendWarrior]

Haven't dealt with Access in over 3 years now and I'm a little more than rusty.. hoping this'll be a quick fix..

I have a form which contains a combo box. The combo box pulls data from one field of a table. The field isn't a key field so it has several duplications. How do I filter the combo box into not showing the duplicates?

Thanks.

 

[hermanlaksko]

SELECT YrTbl.YrField
FROM YrTbl
GROUP BY YrTbl.YrField 'This does the trick

 

[WeekendWarrior]

Outstanding! Thanks a ton chief.

 

[mrf1xa]

I'm sure its not meant to work this way WeekendWarrior- you ask a question, get an answer then GIVE YOURSELF A STAR??
I think the star belongs to hermanlaksko!! lol Nigel
Didn't someone say work is supposed to be fun? They didn't have computers then I guess....