Prompt for user name

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

Guest

I have a report in which I would like to have the name of the person who ran the report in the heading. I was able to do this when the reports data source was based on a query by adding a text box [Your Name]. When the report was run, it would promt for the parameter and display it nicely. The problem is that I have modified the report to include 3 subreports that contain all the data for the report. The main report is now just a shell and is not linked to any queries. Since I made this change, the report no longer prompts for the perameter value and I can not figure out how to get a prompt for the users name.

Thanks for your help
 
I have a report in which I would like to have the name of the person who ran the report in the heading. I was able to do this when the reports data source was based on a query by adding a text box [Your Name]. When the report was run, it would promt for the parameter and display it nicely. The problem is that I have modified the report to include 3 subreports that contain all the data for the report. The main report is now just a shell and is not linked to any queries. Since I made this change, the report no longer prompts for the perameter value and I can not figure out how to get a prompt for the users name.

Thanks for your help
Click to expand...

Add an unbound control to the Report Header.
Set it's Control Source to:
= "This letter is being sent to you by " & InputBox("Enter your
Name","Who am I?")
 
Back
Top