Active X Calendar

[ddbrook]

I have a form that dispays the calendar...

What I need is when I choose a time sheet to print I want the date field to fill in on my report from my calendar.

Right now I am prompting with a parameter.

I want to be able to click a sbegin date and then an end date and show on my report. Without having to key in any dates.
I want to be able just to click the dates I want and it will run the report from those dates...

Can this be done??

Thanks for all your help!
Great Forum!

ddbrook

 

[3699wat]

On the report (maybe the header) add a textbox and in the control source enter

="From " & Format([Forms]![FormName]![BeginningDate]," mm-dd-yyy ") & " through " & Format([Forms]![FormName]![EndingDate]," mm-dd-yyyy")

FormName being the form that holds your calendar control