Using A Cal Control On A Form

[mhoctober]

Experts...

via a report my access database produces a driver run sheet for me and on this I want to have two cal controls.

On the printed out report the first cal controls date value should show the current date and the second cal control should show a date 30 days in the future.



So this is the code I am using in the Load event of the report..

me.Cal1.value = date
me.Cal1.value = date + 30

However the cal controls both show the date that was selected in design mode - before the report was run?

Any ideas?

[mhoctober]

Oops! The title of the post should read Report not Form.

[kennejd]

You don't need to write code for this....just attach your functions to the control source of the report control...= date() For your date + 30 function, I would try a dateadd function: =dateadd("d",+30,date())