Insert Date on Report...

[JuztinMedia]

I have a report. I want the date to print at the top of the printed copy. But, I want the user to enter the date from the Switchboard. How do I tell the switchboard to prompt for a date when a user presses "Print Report" and then have the date they enter appear at the top of my report?

 

[petrosky]

Hi,

One way would be to put an unbound text box on the Switchboard.

Now on your report place another unbound text box and set it's control source to

=[Forms]![Form1]![date]

Where Form1 is your swithboard form and date is the unbound text box on the form.

If you want a dialogue to "pop up" you can make a small form that is triggered by the onclick event which essentially does the same stuff as above.

I hope this is some help for you.

Peter Remember- It's nice to be important,
but it's important to be nice

 

[ButchSchweitzer]

Another way would be to place the a text box on the report where you would like it to print, set the control source to "=[Date Printed]". Every time the report is printed a dialog box will open prompting for "Date Printed"

Good luck