Unbound Date Picker in Report

[wtucker]

Hey Everyone,

My issues seems really simple but I can't figure it out.

We want to add a date picker to a report. The date doesn't need to be saved anywhere, so the control is unbound.
I just want to be able to open the report, click on the field, and open the date picker.
I tried adding a text box and setting the format to short date, but I'm not getting the date picker.

Thanks!

[ranman256]

you dont open date pickers in reports.
you set the date in the Form, then open the report which reads the pick date.

1. on a form put the text box. Set the format of the text box to short date. Now the picker will appear.
2. enter a date in the box
3. open the report

docmd.openreport "fMyReport",,acViewPreview ,,"[dateFld]=#" & me.txtBox & "#"

[June7]

Agree with ranman. Even though ReportView allows typing into UNBOUND textbox on report, best practice is to use form for input/selection of filter criteria.

The $ is a typo, should also be #.