Sub Report Query Within A Report

  • Thread starter Thread starter J
  • Start date Start date
J

J

I have sub reports in the Report Footer section of a main report. Each
of the sub reports uses a different query but in each query it requests
the same information from the same table when looking at which
information to bring back. I was wondering if there was a way that I
could take what is entered in the first text box when it comes up and
tell all the other boxes that will pop up to use the same information.
So rather than typing in B01 in about 10 boxes, I'd type it once and
then the other boxes would automatically be set as B01 so i didn't have
to enter it. And by the way, if I take the search out of the query, it
searches the whole table which I don't want.
 
It sounds like you are using a parameter prompt in your query. If so, don't.
Change this to a reference to a control on a form. This is much more
flexible and provides a better user interface.
 
Yes but the only problem is that I don't want to enter in the data 10
times each time I run the report because it becomes very redundant and
irritating for the person who is currently accessing the report. I
need to find a way around this.
 
Yes but if you have a form open with the criteria value in a text or combo
box, the person only needs to enter or select the value once.
 
So now the problem is how can I get a form's (You did mean form and not
report/sub report right???) combo box to equal the number that I type
in when the query prompts me for the number. The number could be any
number depending on which job the user is looking for. If you could
provide more information on how to set something like this up it would
be very helpful.
 
Back
Top