How to stop the combo box from repeating values

I am using Access 2007 and I'm trying to get a combo box to display the
artists I have in my database but every time I go to another record or close
out the database and open it up again, it automatically duplicates one or
two names into two additional lines. How can I make it display only the names
I put in it? This usually happens when I try to use a query. However I don't
know of any other way to get the combo box to display the names. I'm also
using the limit to list and not in list properties.
Can someone help me on this?. Thanks for your help in advance.

"AccessComp" wrote in message
...
I am using Access 2007 and I'm trying to get a combo box to display the
artists I have in my database but every time I go to another record or
close
out the database and open it up again, it automatically duplicates one or
two names into two additional lines. How can I make it display only the
names
I put in it? This usually happens when I try to use a query. However I
don't
know of any other way to get the combo box to display the names. I'm also
using the limit to list and not in list properties.
Can someone help me on this?. Thanks for your help in advance.

In the query that is feeding the combo box, are the names duplicated? If so,
you should be able to add DISTINCT to the query to show only one of each
value.

Carl Rapson

I inputed it as SELECT DISTINCT before the query and it keeps erasing the
last name on the list and inputs the name I have selected so I still have two
George Jones' in my list. What am I doing wrong?
"Carl Rapson" wrote:

"AccessComp" wrote in message
...
I am using Access 2007 and I'm trying to get a combo box to display the
artists I have in my database but every time I go to another record or
close
out the database and open it up again, it automatically duplicates one or
two names into two additional lines. How can I make it display only the
names
I put in it? This usually happens when I try to use a query. However I
don't
know of any other way to get the combo box to display the names. I'm also
using the limit to list and not in list properties.
Can someone help me on this?. Thanks for your help in advance.

In the query that is feeding the combo box, are the names duplicated? If so,
you should be able to add DISTINCT to the query to show only one of each
value.

Carl Rapson

Are you certain the names are exactly the same? Any difference, even an
extra space between the first and last name, would make the two names
different.

Beyond that, it's hard to tell without actually seeing what you're
describing. It doesn't sound like anything I've seen before.

Carl Rapson

"AccessComp" wrote in message
...

I inputed it as SELECT DISTINCT before the query and it keeps erasing the
last name on the list and inputs the name I have selected so I still have
two
George Jones' in my list. What am I doing wrong?
"Carl Rapson" wrote:

"AccessComp" wrote in message
...
I am using Access 2007 and I'm trying to get a combo box to display the
artists I have in my database but every time I go to another record or
close
out the database and open it up again, it automatically duplicates one
or
two names into two additional lines. How can I make it display only the
names
I put in it? This usually happens when I try to use a query. However I
don't
know of any other way to get the combo box to display the names. I'm
also
using the limit to list and not in list properties.
Can someone help me on this?. Thanks for your help in advance.

In the query that is feeding the combo box, are the names duplicated? If
so,
you should be able to add DISTINCT to the query to show only one of each
value.

Carl Rapson