Connecting Tech Pros Worldwide Forums | Help | Site Map

Linking one calendar to another

Newbie
 
Join Date: Sep 2006
Posts: 25
#1: Sep 25 '06
Hello!

I have two calendars on two different forms. How do I link them so that if the user selects a date on the first calendar, it will automatically make the calendar go to that date on the second screen.

For instance, user selects June 3, 2006 on the first screen and when he/she opens the second screen, the calendar is on June 3, 2006. This is the Microsoft Calendar control 11.0 that I am talking about, if that makes a difference.

Thanks for whatever help you can give me!

Rio

PEB's Avatar
PEB PEB is offline
Expert
 
Join Date: Aug 2006
Location: Bulgaria
Posts: 1,380
#2: Sep 25 '06

re: Linking one calendar to another


Try :
As After Update Event procedure of Calendar1 type:

Me!Calendar2=Me!Calendar1

I've never tried with this kind of controls... But the rules about the controls are identical... In the more cases!


:)
Newbie
 
Join Date: Sep 2006
Posts: 25
#3: Sep 25 '06

re: Linking one calendar to another


I got the answer from another source. I was told to use:

Private Sub Form_Load()
Me.NameOfSecondCalendar.Value = [Forms]![NameOfFirstForm]![NameOfControlWithDate]
End Sub

Slick as can be! Works perfect!

Rio
Reply


Similar Microsoft Access / VBA bytes