Personal input field in a report from a query.

  • Thread starter Thread starter Louise
  • Start date Start date
L

Louise

Is it possible to have a field in the title of a report
that the user can fill in before the report is printed?
I am creating a switchboard as the user is unfamiliar
with Access but the report I have created needs to have
the appropriate month noted each time. There is no field
within the report that can accurately reflect the month
needed in the title. I need to be able to let the user
type in whatever is appropriate.

I hope I have missed something simple. Can anyone help?

Thanks!
 
Louise,
On the report, in Design mode, place a text control (ex. name =
UserEnteredMonth) with this ControlSource...
= "This Report is for the Month of " & [Enter Month Name]
When the report runs, since Access doesn't know what [Enter Month Name] is,
it will pop up an Input box asking for the value of [Enter Month Name]. If
the user enters "December" in response to that, the report when previewed or
printed will display...
This Report is for the Month of December
Since this "parameter" value is not saved... every time the report runs, the
user will be prompted for the value.
hth
Al Camp
 
Back
Top