No duplicates in Combo Box

[Guest]

I have a combo box that looks up data from a table. The table contains
duplicate values, I want my combo box to ignore all duplicates. Is this
possible?

JV

 

[Al Camp]

Use a "Totals" query as the RowSource for your Combo, and Group accordingly
to avoid the dupes.

 

[Z]

could you elborate more on what you mean by "totals"? im having a
similar problem, but instead made another table, but if its possible to
do it with the same table by eliminating the duplicates that would be
most helpful! thanks!

Z

 

[John Vinson]

I have a combo box that looks up data from a table. The table contains
duplicate values, I want my combo box to ignore all duplicates. Is this
possible?

JV

Rather than using the Table as the row source for the combo box, use a
Query on the table. Set the Query's Unique Values property to True to
suppress all the dups.

John W. Vinson[MVP]

 

[Al Camp]

Z,
A "Total" query is a type of query like an Update query or a MakeTable.
Open your query in design view and select View/Totals. Now you can group
similar values and also derive Sums/Avgs/Mins/etc.. for number field
associated with those groupings.
Access Help, or any beginner's reference book will tell you how to use
Totals queries.

 

[Z]

thanks for the responses,
I was able to use a query in the combo box. I also need to add that,
you need to make sure that the query is the right 'type'.

(for those who are not completly adept and teach themselves, like
myself, heres what I did to get it to work =) )
create a query of a table, then
open it in design view, right click on the top of the window where the
table items are
look for Unique Value or Unique Record, depending on what your doing.
set it to true, then right click on the top of the window where the
table items are and
go to query type and "i clicked on" - select query. i tried to do a
make-table query, and it didnt work, then go back to your form, and
right click on the combo box that you want and find the query that you
made, viola!

Z