Prompt in a Report

  • Thread starter Thread starter Maura
  • Start date Start date
M

Maura

I have a report based on a query that prompt the user for the Relationship
Manager name when opened. When I run the query by itself there is only one
prompt, however when I open the report, the same prompt comes up 3 different
times. I figure that this has something to do with the layout of my report,
but is there a way to make it only come up one time?

Also, is there a way for the prompt to be a drop down menu with a list of
all the relationship managers?

Thanks for your help.
 
Does the report have subreports? That might cause it. What you can do is have
a form open and have the user enter the prompt in an unbound text field. Then
click on a button to run the report. On the report reference the form with
something like Forms!frmName!txtPromptField when the prompt was in the query.
The form must remain open for this to happen, but can be hidden.

Another possibility if there are subreports is that the variousn reports
aren't linked properly. Basically they then all run as seperate reports and
need individual inputs like described above.

Another possiblility on reports is in sorting and grouping. If you sort or
group on a field then delete or rename that field, Access will prompt you for
input until you delete the sorting and grouping. One way to tell this is to
not enter something in one of the promts and see if the report still works
properly. You may need to test this on each of the prompts.
 
Thanks so much for your suggestions. I beleive the sorting/grouping was part
of the problem.

The other part is the subreport. I have a subreport in the report footer,
and I basicaly just created a copy of the same Query except without the
prompt, and linked the subreport to that- which predictably resulted in the
subreport pulling all of the information and not jsut the information for the
prompted Relationship Manager.
How do I make sure that the report and subreport are linked properly as you
mention?
If the solution is to create that hiden form, could you possibly give me
more details on that? I was having a little trouble following your repsonse.

Again, thank you!
 
Back
Top