Re: Filter Duplicate Entries

George,

You are correct, that unique ID is going to cause duplicate entries and
deleting it will cause issues with the report. What are the other fields in
the table? Perhaps you can include one of those in the combo box to rid
yourself of the duplicates but other than that you might be right about
having to live with it.

tblAcitivites
aActivityID
aActivityTypeID
aClientID
aNotes

The above allows a combo box to look up activities by Client and then print
an individual activity for that Client., allowing no duplicates in the combo
box, as you can use ClientID in the combo box. Find all the activities in
that form below can click on the one you want to print. The below means you
will see mulitple activities in the combo box and no way to avoid that (that
I know of) get rid of duplicates in the combo box


tblAcitivites
aActivityID
aActivityTypeID
aNotes

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II
"George" <George@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:484961E2-C4DE-4CD3-9EBF-BEE93281893C@xxxxxxxxxxxxxxxx
Gina - After reading your question I looked at the query the Combo Box it
gets it data and there are two fields the auto "ID" field, which is the
primary key, and the field I need "Activity". When I delete the "ID" field
it
solves my problem, display only unique values, but it causes problems
with
my reports.

Any ideas - I think I may have to live with this...

George


"Gina Whipp" wrote:

What are the fields in the combo box? And post back if one of those keys
is
a primary key. Also what does the combo look-up? is it Orders, Purchase
Orders, etc...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

"George" <George@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AD27C10A-2A25-4918-9E2B-F7C9072C5E95@xxxxxxxxxxxxxxxx
Gina - Tried your suggestion - so far either I have muliple entries of
the
same value or a totally blank Combo Box, Still trying.

Thanks - George

"Gina Whipp" wrote:

George,

Go into design view, bring up the proerties of the combo box and where
it
says Row Source, click the button to the left (with the 3 dots on it)
and
then in query grid press the Totals button. Say yes to the changes
and
providing there are no unique fields your combo should show one entry
instead of multiple same entries.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II
"George" <George@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:62C4ACB7-6CEC-4815-B88F-D941BBB26C1D@xxxxxxxxxxxxxxxx
My combo box is based on a Query / Table that allows duplicate
entries,
is
there a
way to filter the combo box so that it doesn't display the duplicate
entries
?

Thanks









.