Hello,

I have read through some of the posts regarding this problem with a report
prompting for "enter parameter value", here is what I have tried to fix my
problem.  I hope you can help and thank you for trying.

error
 enter parameter value
   qry_pir_1

background
 1. main report works fine
     rptPIR
           qry_pir_total (made up from 8 sub-queries)
              qry_pir_1 through qry_pir_8

       
 2. added a subreport, this is when the "enter parameter value" started
appearing
     rptSubBedrooms
           qry_pir_8
1) used this code which had the listed results, for trouble-shooting
  ? CurrentDb.QueryDefs("qry_pir_1").Parameters.Count
      0
   ? CurrentDb.QueryDefs("qry_pir_1").Parameters(0).Name
      run-time error '3265': item not found in this collection
2) Checked the main reports filters
     none
3. checked main reports grouping
   none apply to the error
    when I remove the subreport:rptSubBedrooms the error goes away, so i
know it is in there somewhere

4) rptSubBedrooms, does not have any groupings or filters

5) rptSubBedrooms
      source object form.rptSubBedrooms
      link child fields : property_id
       link master fields : qry_pir_1.property_id

6) each query works fine if run alone.

7) if I run the main report:rptPir without the subreport it runs fine

8) if I run the sub-report:rptSubBedrooms by itself, it runs fine

sorry if i missed any information that would help diagnose this problem,
please ask anything and I will respond.

thank you,