Prev: Is Null in a Report
Next: Group totals in dynamic report
From: AccessKay on 26 Apr 2010 14:33
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.
From: Marshall Barton on 26 Apr 2010 15:28
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]
From: Steve on 26 Apr 2010 15:28
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
santus(a)penn.com



"AccessKay" <AccessKay(a)discussions.microsoft.com> wrote in message
news:32001A64-5D67-4DDC-8D3A-DE62CE9AAFD0(a)microsoft.com...
> 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.


From: AccessKay on 26 Apr 2010 16:07
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]
> .
>
 | 
Pages: 1
Prev: Is Null in a Report
Next: Group totals in dynamic report