Criteria from form on report

[AccessKay]

If you have an unbound form that you use for criteria and you want your
report to display the criteria selected by the user in the page header, how
would you do that?
Thanks for any suggestions.

 

[Marshall Barton]

If you have an unbound form that you use for criteria and you want your
report to display the criteria selected by the user in the page header, how
would you do that?

Use text box expressions in the report that refer back to
the form. Could be as simple as:
=Forms![unbound form].[criteria textbox]

 

[Steve]

Put an unbound text box named ReportCriteria in the page header and put the
following in the report's header format event:

Me!ReportCriteria = Forms!NameOfUnboundForm!NameOfCriteriaField

Steve
(e-mail address removed)

 

[AccessKay]

Wow...something actually simple in Access. This worked perfectly. Thank you
very much!

If you have an unbound form that you use for criteria and you want your
report to display the criteria selected by the user in the page header, how
would you do that?

Use text box expressions in the report that refer back to
the form. Could be as simple as:
=Forms![unbound form].[criteria textbox]