Customize a report with an inputbox?

[Guest]

I have a button on a form that will generate a report that is used as a form
letter based on data displayed on the form. Depending on the data in a
certain control on the form, is there a way to raise an inputbox just before
the report is created to ask the user for custom input that will be used in
the text of the report? Since this report is general purpose I only want the
inputbox raised if the value in a control is equal to a certain value which
is rare. I don't think I want to use a parameter in a query that would have
to be answered everytime the report is run.

 

[Al Campagna]

Dvanwig,
Just place a text contol on the report with a ContolSource of...
= [Enter the Report Text]
When the report opens, it doesn't know what [Enter the Report Text] is, so it will open
an Input Box auto-magically for you to supply the textm before the report opens.

 

[Guest]

HI Al,
Unfortunately when I try the suggested method, the report prints "#Name?"
without poping up a dialog box to enter the data. Is this fixable?

Dvanwig,
Just place a text contol on the report with a ContolSource of...
= [Enter the Report Text]
When the report opens, it doesn't know what [Enter the Report Text] is, so it will open
an Input Box auto-magically for you to supply the textm before the report opens.

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

I have a button on a form that will generate a report that is used as a form
letter based on data displayed on the form. Depending on the data in a
certain control on the form, is there a way to raise an inputbox just before
the report is created to ask the user for custom input that will be used in
the text of the report? Since this report is general purpose I only want the
inputbox raised if the value in a control is equal to a certain value which
is rare. I don't think I want to use a parameter in a query that would have
to be answered everytime the report is run.

 

[Guest]

Al,
Please disregard my previous response. There was a different error. Your
suggestion worked perfectly. Thank you.

Dvanwig,
Just place a text contol on the report with a ContolSource of...
= [Enter the Report Text]
When the report opens, it doesn't know what [Enter the Report Text] is, so it will open
an Input Box auto-magically for you to supply the textm before the report opens.

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

I have a button on a form that will generate a report that is used as a form
letter based on data displayed on the form. Depending on the data in a
certain control on the form, is there a way to raise an inputbox just before
the report is created to ask the user for custom input that will be used in
the text of the report? Since this report is general purpose I only want the
inputbox raised if the value in a control is equal to a certain value which
is rare. I don't think I want to use a parameter in a query that would have
to be answered everytime the report is run.