How can I remove duplicates on my Combo Box 1

[thembela]

Broker No Broker Name Month Premiuns
1028811162 ABDOL,VE,MR 01/08/2005 3000
1028811162 ABDOL,VE,MR 01/09/2005 16692
1028811162 ABDOL,VE,MR 01/10/2004 48
1068787405 ABDUL,P,MS 01/08/2005 56100
1068787405 ABDUL,P,MS 01/09/2005 41376
1068787405 ABDUL,P,MS 01/10/2005 19092

I have a table that tracks broker production on a monthly basis. Each and every month a database has to be updated with new premiums.

This could be a wrong table layout .I have a combo box on my form that looks up the broker number and diplay the information about that broker. When I click on the drop down arrow. It lists the same Broker number for a every month ( e.g it lists 1028811162 three times).How can I remove the duplicates broker numbers on my Combo Box. Here’s an example of my table. My combo box is based on the above table.

 

[ZmrAbdulla]

In the rowsource property of the combo you can see the SQL like

Select ......

Change it to

Select DISTINCT ......

________________________________________________________
Zameer Abdulla
Help to find Missing people
My father was a realistic father; not a vending machine dispense everything I demanded for!!