duplicates in combo box

[crazyITguy]

how can i stop from getting duplicates in a combo box

Thanks

 

[Jeff Boyce]

Without that combo box's underlying row source SQL statement, and without an
idea of what the underlying data structure looks like, I could only guess...

Are you using a query for the 'source'? Is there a join in the query? What
happens if you only run the query -- duplicates?

 

[Cheryl Fischer]

If the Row Source of the combo box is a table that contains already contains
duplicates of your combo box items, you could make the Row Source a query of
that table using:

Select Distinct Field1, Field2 ...

Or, if your users are inadvertently entering duplicate values rather than
selecting them, set the Limit to List Property of the combo box to 'Yes'.

hth,

 

[CrazyITGuy]

its just a basic combo box that i am pulling from a field. Such as work job code, there is multiple values of that job code in the field. When i edit the combo box in the row source i put

SELECT

.job_code FROM

then i execute a query that only brings the value of what is in that combo box

hope that helps

thanks again!

 

[Cheryl Fischer]

See if replacing the existing Row Source of your combo box with the
following will work for you:

SELECT DISTINCT

.job_code FROM

;


hth,
--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

its just a basic combo box that i am pulling from a field. Such as work

job code, there is multiple values of that job code in the field. When i
edit the combo box in the row source i put :

SELECT

.job_code FROM

;

then i execute a query that only brings the value of what is in that combo box.

hope that helps.

thanks again!