Re: Filter Duplicate Entries

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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







.

Quantcast