Filter Duplicate Entries

[George]

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

 

[Gina Whipp]

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.

 

[George]

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 - 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]

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...

 

[George]

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]

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

 

[George]

Thank you Gina for your time, you pointed me in the
right direction - I will continue to play with it - but to fix it would
require a major restructure which I am not prepared to do.

George