Combo box contains years

[antifashionpimp]

Hi,

how do I get a combo box in access to contain all the years from e.g. 1900 till present?

Please, is there an easier way than filling in each year seperated with commas in the properties of the combo box?

Regards,
Jean

 

[KenHigg]

Base it on a table...

???
kh

 

[antifashionpimp]

thanks, thought of that.
thought there was maybe a way to autogenerate such a list with e.g. a for loop.
?

 

[KenHigg]

When the form opens you could do a pc of code the that builds the string with a loop then set the row source to that string.

???
ken