Hi,
I have a database of say 500 employees working is say 25 departments. I created a combobox in a form to lookup a value from the table and selected the field department from the database table with ascending sorting over the field. The combobox is working fine but the problem is that repeated entries are showing in combobox. Like in department A say 10 persons are working and likewise in another departments and when I click at combobox, it 10 times shows department A and I want that it may show it only one time and if there are duplicacy of any value in that field than only once the combobox should show the value. Pl. help