Date Picker value not passing from FORM to the REPORT

[vikash.verma]

Hi All,
I have used 2 Date Pickers(Microsoft Date & Time Picker Control Version 6.0)
in my FORM.But i am not able to pass the Value of this Date Picker into my
Report.
For eg
if the Date Picker name is 'DP1' in the FORM.
I am not getting the name at all while generating the Report.So there the
value never comes up.

What can be the problem?

I am expecting a mail from you all.

Regards,
Vikash

 

[Charlie]

There is an excellent article on calendar controls by
Frank C. Rice. Have a look.
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnacc2k2/html/odc_acdates.asp

Also do a google search on Calendar Controls for more info.

Charlie O'Neill

 

[Nikos Yannacopoulos]

Vikash,

You don't get the DTPicker in the fields list in your report design view
because it is not a field in the table or query that is the report's
recordsource!
You can get it by manually creating a textbox, and referencing it directly
in the ControlSource property:

Forms!FormName!DP1

(replacing FormName with the actual form name), provided you keep the form
open while you run the report.

P.S. Don't ask for replies via e-mail. Replies are posted in the newsgroup,
for the benefit of others with similar questions.

HTH,
Nikos