Macro Error??- ActiveX Calendar Control

[nicky1234567]

Hi, i searched the forum for code on how to get my ActiveX calendar to automatically update todays date and for this to be shown every time the main menu form is opened. The code that I obtained was

Me.Calendar2.Value = Date

Calendar 2 being the name of the object

I entered this code as it said in the OnLoad box in the Form Properties.

When i now open the form I get the error message ' Microsoft Access can't find the Macro 'Me'.

Do i need to create a Macro for this and what properties should the Macro have or is there another way around the problem. I am a novice Access user and am struggling. Any help would be greatly appreciated.

Thank You

 

[Uncle Gizmo]

All you need do is use the built in function Date() and that will give you the date.

however I am not sure exactly where you want this date to appear? do you want it to display the default value for a text box, do you want it to just display on the form in a label for the user to see the date? Or do you require some other method?

Please could you provide more information.