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 Removed)



"AccessKay" <(E-Mail Removed)> wrote in message
news:32001A64-5D67-4DDC-8D3A-(E-Mail Removed)...
> 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.

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


"Marshall Barton" wrote:

> AccessKay wrote:
>
> >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]
>
> --
> Marsh
> MVP [MS Access]
> .
>