Use Parameter Criteria in a Report HELP!

[newbie]

I currently have a drop down box where I select a client name, this filters a parameter report which asks the end user to enter a start date and end date and then in turn creates a report for a specific client and date range. On my report I have two unbound text boxes where I have set the control source to the parameter query [start date] and [end date]. This works great....when there is data returned between the date range entered. However, when no data is returned I lose my client name field as well as the two parameter criterial fields. How do I retain these pieces if info so that when the report opens the text box I have set to be visible when no data returned will read "No results found for ClientX for the date range of start date - end date"?

[June7]

I almost never use dynamic parameterized queries. I never set queries with popup input prompts. I use forms for user input of filter criteria. Then I use VBA code to construct filter criteria and apply to form or report when opened. Query can reference controls on form for criteria parameters. Textboxes on form or report can reference the criteria input controls on form.

[newbie]

Yes, I have seen some blogs and post about using forms. That seems very complicated and may be a little out of my expertise! I thought I was doing good just to make my drop down box filter my query. I will start down that path I guess. If anyone else has any other suggestions a little more beginner friendly I would love to hear them!

[June7]

I really don't think there is another way to go. Dynamic parameters in query will filter records but as you found out, if no records meet the criteria then there is no data for the report to display, not even the parameters.

Referencing controls on form not that much more difficult. Although, Access 97 might not have as friendly an interface to aid in building the references.

[newbie]

It took a lot of persistence and trial and error but I am happy to report that I was able to accomplish the task of using a form to capture my parameters and can successfully use the parameters in my report EVEN when no results are returned in the underlying query. The link below was a huge help! I hope others struggling with this issue find it useful.

http://office.microsoft.com/en-us/ac...005187411.aspx