enter parameter value?

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

Guest

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,
 
Have you Made sure that the property_id field from qry_pir_1 is included in
you main query for the report - qry_pir_total? If so, are you running any
kind of filter when you open the report?

Katrina
 
Hello Katrina,

Yes, property_id, is in the qry_pir_1 and is also in qry_total, which
contains query:qry_pir_1

on the main report, Filter On: no, but there is a FILTER
filter: (manager = 'bob jones')
this is because I'm selecting a manager from a list-box on the form that
calls this report. I do get the same error "enter parameter value?" if I do
not enter any manager and retreive ALL managers.

on the sub-report, there is no filter


thanks,

phil
 
Back
Top