Display parameter prompt in Report

[icsupt]

I have a report that is based off of a query. In the query, I prompt for employee's name [EEName]. The EEName may be in several places, so I added a field that combines all of the several places in one field. Then I put in a prompt that asks for the employee's last name.

EENameAll: [Field1] & [Field2] & [Field3]
Like "*" & [Enter the last name to search by: ] & "*"

What I want to do now is display whatever the user typed in. I used ="Employee Name " & ([EENameAll]), but that gives me all of the names in a string.

In other words, when prompted for last name and I type in Jones, I want Jones to appear on the report.

How do I do this?

Thanks in advance.

 

[traingamer]

Use the parameter, itself:

="Employee Name " & [Enter the last name to search by: ]

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[smedvid]

Another method I've used is the "OpenArgs" parameter for reports (and forms) to pass in filter conditions.

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[dhookom]

OpenArgs is fairly new in Access Reports. I don't think you will find this in version 2000 and earlier.

I don't use parameter prompts since they are not very usefull. Referencing controls on forms for criteria provides much more functionality.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]