ernielippert
Registered User.
- Local time
- Today, 10:37
- Joined
- Sep 11, 2012
- Messages
- 13
My form contains a series of check box controls RecdCard2000, RecdCard2001, RecdCard2002… RecdCard2012, RecdCard2013 … . There is another check box, Last Year, which currently has for its Control Source: RecdCard2011. Every year I change this manually. I want to change the Control Source to: ="RecdCard" & Right(Str(Year([Date])-1),4) so that it automatically updates each year. However, this expression does not work. The Last Year check box on the form is greyed out. Why?
Thanks,
Ernie
Thanks,
Ernie