Calculated RowSource

[mikemaki]

This should be an easy one (at least it sounded easy when I was given the task). I have a combo box in which I would like to display a list of budget years ie 2004;2003;2002;2001. In my RowSource I entered Year(Date())+1;Year(Date());Year(Date())-2. That is exactly what displayed - my expressions not the calculated values. I've tried with preceding equal signs too. Nothing seems to work. Is it possible to calculate values in a value list?

 

[Rich]

Use the Combo Box wizard to create the query from your table, MyYear:Year([MyDateField]) select unique values, the query will then return the years from dates already entered.
You should also rename your field Date to something else, it's a reserved word in Access.