Creating a user dataentry field on a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to enter the year on a report that I print only once a year....
I would like a function box to pop up and say "enter year" and then the
report opens and the year is printed in the area I've placed the text box or
what ever I have to do to get the year to print in the header. How can I do
this.

Thanks,
Janet
 
You can, of course, get a lot more sophisticated than this, but the
quickest, simplest solution would be to place a text box in the report
header (make sure it's the report header, not the page header) and enter the
following in the Control Source property of the text box ...

=InputBox("Year?")
 
I'd like to get more sophisticated and for the life of me I can not think of
how I'd even go about it. I've been able to create reports that ask for
start and end date so the data in the report is what I want it to be but
beyond that I'm stumped as what or how I'd automate this better. Thanks for
your help it will get me through for now....<s>

Janet
 
Back
Top