Problems with a sub report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have 1 report and a sub report they are both based on the same query.The
query prompts the users to enter a value and then prints out the report.I
have used a sub report to create a list form the same query but whne I place
it onto the main report it repeats the same prompt ten times and the staus
bar at the bottom says Please wait formating.I don't know why this is but I
want to supress the prompt from being repeated.Any answers would be greatly
appreciated.
 
M,
If the query behind your main form has a parameter, and you used the same
query for your sunform, then that parameter will be requested for every
subform record.
Call your sub query another name, and remove the parameter. The
Master/Child linking between the Main and Sub should maintain the
realtionship between them.

But... I'm a bit confused as to why you have a subreport with the same
query as the Main. Usually a subreport is used to display related
information from another table. Like a Name as opposed to multiple phone
numbers for that Name... rather than Name related to other Name values.
Well, we won't dwell on that, but I thought it a bit odd.
My solution should work as far as the parameter problem...
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
Back
Top