Hi,

I want to place a list/combo box on a form to look up a column in my database.

However the column contains multiple duplicates and I don't want to be able to see these.

I only want to be able to see any individual value once.

If it is repeated in the database then I don't want to be able to see the duplicate(s).

Someone told me how to do this once before but I can't remember how it's done.

Can anybody help?

Best Regards,

Rob Brown.