Date Picker value not passing from FORM to the REPORT

  • Thread starter Thread starter vikash.verma
  • Start date Start date
V

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
 
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
 
Back
Top