Ignoring duplicates in table field values that is for a combo box drop down list

[enquiries]

Hi there,

I'm trying to create a combo box that takes its values from a field in a table, the thing is that this field has duplicates because:
* The table is a qualification look up table
* It has 3 fields: QualificationID (autonumber), Qualification(e.g. Bachelor), Programme (e.g. Science)


* E.g of duplicate values (this is not a problem as it is necessary) Bachelor of Science, Diploma of Science, Certificate of Science

What I'm trying to do is create 2 single-columned combo boxes that are a parameter for a query and it's working except the combo boxes show duplicated values
Is there a way to get the query that is the row source for the combo box to eliminate duplicates?

Any help, much appreciated
Thanks

[trevor40]

you will need to base the combobox record source on a totals query, add the field to the query and select totals. the field will show group by. use this as the source of the combobox. there is also an option to use distinct, but i've never needed to use that.

[enquiries]

Works Perfect!!! Thanks, that's exactly what I needed.