Changing Months in the calendar function

[Pilgrim]

Folks,
I've got a calendar set up so the month and year can be changed, which it does beautifully. However, I need to set it up so it selects the first day of the month for the new month or year.

I suspect it will involve something clever with Me.Calendar.Value but right now I'm not clever enough. Do any of you have any ideas?
Thanks,

 

[Pilgrim]

thread bump

thread bump
Has anyone managed to do this with the activex calendar form?

 

[Mile-O]

If you have the month and year and want the first day then use the DateSerial(year, month, 1) function.