Criteria from form on report

  • Thread starter Thread starter AccessKay
  • Start date Start date
A

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.
 
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)
 
Wow...something actually simple in Access. This worked perfectly. Thank you
very much!


Marshall Barton said:
AccessKay said:
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?
Click to expand...


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