How to change the Year?

[mv8167]

VIns

That did the trick. I have never used CStr but I will now. Thx!

For those who are interested:
These:

Code:

intYear = Year(Now)
Min3Year = CStr(intYear - 3)
Min10Year = CStr(Year(Now) - 10)

Return these:
2011
"2008"
"2001"

The "2008" and "2001" with quotes is what I need to change a combo box.

thx
Lorena

---

How about the Month?

I have:

Code:

intMonth = Month(Now)

Min1Month = CStr(intMonth - 1)
Which gives me "8".
or
Min1Month = intMonth - 1

Which gives me 8.

How do I change the "8" or 8 to "August"?

I figured it out, nvr mind.

Code:

intMonth = Month(Now)
Min1Month = intMonth - 1
ThisMonth = MonthName(Min1Month)
or
ThisMonth = MonthName(Month(Now) -1)