Table has multiple years but want combobox to show only one

[Tron142]

Hi,

I have a table that has many records that show the same year. For example

2011
2011
2011
2012
2012
2012


...etc

In one of my forms, I want the user to be able to select a year, BUT I only want to show the years shown in my table. Upon selecting the year, it would open a report showing ONLY that year.

I can't figure out how to make my combo box show only 2011 or 2012 or 2013 once instead of showing EVERY record in my table

Pleeeeaaasssseee help!

Thanks,
Tron

[Bob Fitz]

I think you need to add a "Group By" clause to the SQL statement in the Row Source property of the combo box.

[NoellaG]

Hi,

add DISTINCT to the SQL of your rowsource,:

SELECT DISTINCT [fieldname] from [tablename] order by [fieldname]

[Tron142]

Tried the "Group By" In the SQL Statement under Criteria and still I get an error message "Data type mismatch in criteria expression"

[Tron142]

NoellaG, I tried the "DISTINCT" to the rowsource. It seems all my years disappear and I can't select anything from the combo box.

[Tron142]

nvm, it worked like a charm! Thanks so much!