Calendar Control (Three Months)

[Guest]

I have a form with three one month calendars on it, side by side from left to
right.

I would like the calendar on the left to show last month, the calendar in
the middle to show the current month, and the calendar on the right to show
next month when I open the form.

I would like this to be automatic.

Is there a way to do this?

 

[Guest]

assume your 3 Calendar 's name is LastMonthCal, CurrentMonthCal, NextMonthCal

On form open event to put:
Me!LastMonthCal.Value = DateAdd("m",-1,Date)
Me!CurrentMonthCal.Value = Date
Me!NextMonthCal.Value = DateAdd("m",1,Date)

Rainbow01(from Hong Kong)
30.11.2005


"Beverly76" 來函：