EASY ONE: Calender go to current date

[murphysdad]

I use a calender that comes up as a form. How do I get this calender to be up to date as it opens. It is still reporting from the orignal date I started it.

Thanks,
J

 

[danvlas]

In the Load event of the form:

Private Sub Form_Load()
Me("Calendar&quot = Date
End Sub

Do not try the Open event...it won't work

Good luck

Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[murphysdad]

Thank you but it is not working. Perhaps I should have told you two things:
1. I am using access 97
2. the name of my calendar is frmCalendar

J

 

[tsonnenl]

Is there an error that is produced? Also, try putting a stop next to the code that danvlas suggested and see what happens when that line is processed. I use "Me.calendar1.Value = Date" which is the same as what he suggested, just different syntax and that works.

Todd

 

[mgmslate]

Did you change the name in your activex control to calendar?

Mike

 

[murphysdad]

Me.calendar1.Value = Date worked. Thank you!

Jeremy Link