Have query parameter display in report header textbox 1

[nastar1]

I have a report based upon a query that prompts the user to enter a text string. I would like to display this text string in a text box or label in the header area of the report.

Any tips on how one would do this?

The query criteria is below:

Like "*" & [Enter search text:] & "*"

Would some code go into the Control Source field of the Text Box?

 

[dhookom]

Add a text box to your report header with a control source of:
="You searched for: " & [Enter search text:]

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]

 

[nastar1]

Exactly what I was looking for.

Thanks dhookum, you da man.

 

[nastar1]

I noticed one additional thing that would be nice. If the user enters a parameter that does not result in any records selected, the textbox displays ERROR#.

Is there a way to defeat this and still have the textbox display the parameter input by the user?

 

[dhookom]

=IIF([HasData],"You searched for: " & [Enter search text:],"You didn't return any records.")

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]

 

[nastar1]

Another home run for you dhookum.

Spot on solution for what I needed.

Thanks