"Year" combobox default - can't get it to show

[Montez659]

I have a combobox that will display a list of years to choose. I am not even quite sure of the best way to fill it, but I tried doing it by values and from a table.

Either way, I am not getting it to populate with the current year, which I thought would be a simple

Me.cmbYear.Value = Year(Date())

I can actually get a month box to populate the correct month using this same method above, but it ain't working for year.

Any suggestions? Thanks in advance!

 

[Montez659]

It is unbound, but the Change event triggers a requery for a listbox.

 

[Montez659]

I think that example will work for me. I am almost sure the problem lies with the fact that a pre-made value list only displayed the integer 2010, 2011, 2012... and not the Year of the date. Same for the table, as I only stored an integer and not a date. Adding the year to the combobox like this obviously fixes the problem.

Thanks guys!

 

[Norie]

Montez

A year is an integer and as far asI can see the code posted so far is adding the years as integers.

I know mine is, and I think xenou's is too.

 

[Montez659]

A year is an integer and as far asI can see the code posted so far is adding the years as integers.

Ahhh, who knows then...at least it works!