By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,510 Members | 1,821 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,510 IT Pros & Developers. It's quick & easy.

display selection parameters on report

WyvsEyeView
P: 46
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
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 634
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
P: 46
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.