Sorry for double posting - have most of it working :)

In Label1 get Month and Year (yay!) but year starts 1899. Would like to
have month and year start at one month prior to current month (so the user
would see January, 2010 if they are filling in the form in February 2010).

In Label2 get a number. Starts at number 1 and for each month increase,
counts up by 1. I'm not sure what label 2 represents - which makes me unsure
about needing label 2.

thoughts/solutions?

Thanks a bunch for your help, never thought I'd get so excited to see a
Month/Year show up on the screen ;)


"EnviroGeek" wrote:

Using 2003, I have a form (frmMSW) users input data for monthly solid waste
tonnage by location. Since data is collected monthly, wanted the user to be
able to select Month/Year period covered from a calendar scrollbar. Is it
possible?

FYI - using date picker scrollbar now. Users complaining they don't
understand what "Period Covered" means when the entire month calendar pops up.

Thank you guys for all the support. I've learned much from reading other
problems/solutions.