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
46
