|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 26th, 2010, 07:33 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Criteria from form on report
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. 
|
|
#2
April 26th, 2010, 08:28 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Criteria from form on report
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]
|
|
#3
April 26th, 2010, 08:28 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Criteria from form on report
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 "AccessKay" wrote in message ... 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.
|
|
#4
April 26th, 2010, 09:07 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Criteria from form on report
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] .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
