467,888 Members | 1,379 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,888 developers. It's quick & easy.

display selection parameters on report

WyvsEyeView
I have a form on which users select various search parameters and then click a View button to display a report of the results. I would like to display the search parameters used on the report itself so users can easily see what the results are for. I have tried adding both labels and text boxes to the report and setting their values to the values of the search form but the report does not accept either Me.xxxxx.Value or Me.xxxxx.Caption. I tried creating a sub-form that would read the search form's values onOpen and adding it to the report but when opened from within the report, the subform does not pick up the search form's values. I'm out of ideas. How is it possible to accomplish this? Thanks!
Sep 17 '08 #1
  • viewed: 1404
Share:
2 Replies
Expert 512MB
I have a form on which users select various search parameters and then click a View button to display a report of the results. I would like to display the search parameters used on the report itself so users can easily see what the results are for. I have tried adding both labels and text boxes to the report and setting their values to the values of the search form but the report does not accept either Me.xxxxx.Value or Me.xxxxx.Caption. I tried creating a sub-form that would read the search form's values onOpen and adding it to the report but when opened from within the report, the subform does not pick up the search form's values. I'm out of ideas. How is it possible to accomplish this? Thanks!
Hi

I think you need to set the Control Source of the text box(s) in the Report to the control on the Search Parameters control(s) (the search form must remain open, but not necessarily visible), something similar to this

=[Forms]![frmDwkTracking]![txtFilterText]

This can vary depending on the set up, but in this caes of mine, the txtFilterText value is generated on the fly when the various filter parameters are selected in the search form. The Report Control Source uses the actual Parameter controls as their filter parametes and the Report 'Filtered By' textbox is linked as above.

Also the txtFilterText textbox is hidden on the Search form.

Does that make sense !?


MTB

I think that is what you want ??

MTB
Sep 17 '08 #2
WyvsEyeView
That is perfect. And hugely self-evident...I'm smacking myself for not having thought of it! Thank you!
Sep 17 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Jo Davis | last post: by
1 post views Thread by Reef81 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.