Placing responses to parameters on report

[Varda]

Using Access 2010



I have a report based on a parameter query. The parameter query has three fields with parameters, so when the user opens the report, three pop up parameter boxes appear consecutively.

I would like to show the word typed in the parameter boxes in the header of the report. How would I do that?

The report is opened from a command button on a form.


Varda

[June7]

I NEVER use dynamic parameterized queries. I prefer VBA that builds filter criteria with inputs on form http://www.allenbrowne.com/ser-62.html

Textboxes on report can refer to controls on form.

Otherwise, construct a field in query with the dynamic parameter. Then bind textbox on report to that field.

[JamesDeckert]

Couldn't you just put the parameterized fields into the header? Since they must match what is typed it, the typed value will be in the header.
An alternative would be to add a field e.g. x: [prompt], this prompt must match exactly the prompt which appears in the criteria field. Then you can add the field x to the header in the report. This would capture case differences that won't be caught in the first option above. Below is the SQL of an example, and testFN can be added to the report header. But if no records are returned, you also won't have the typed in data in the header of a report.

SELECT [Enter a First Name] AS testFN, Customer.FirstName, Customer.LastName, Customer.City, Customer.State, Customer.ZIP
FROM Customer
WHERE (((Customer.FirstName)=[Enter a First Name]));

[June7]

Of course the field data will match the parameter if using = operator and a textbox in header bound to that field will show the user input.

However, if the operator is LIKE (with wildcard) or <=, etc. that will not work