Hidden query request in Report design

[Timothy Andrepont]

I am trying to discover the code that is asking for a phantom query in Subreports. Each Subreports control source query works fine.

I have attached two zipped files
1. Database stripped to send
2. SnapShots of the problem.

Let me know if you need any more information.

Timothy

 

[pbaldy]

How to recreate the problem?

 

[Timothy Andrepont]

Paul,

To recreate the problem, simply go to Reports: srpt02WS or any report between this 02 and 11.

Thanks for looking into this for me.

Timothy

 

[pbaldy]

On that report, there's a field in red with this as the control source:

QFinalScore_LessGrinder_LessHatch.MS_PS_ID

That field doesn't exist, should simply be:

MS_PS_ID

 

[Timothy Andrepont]

P,

That is exactly what was wrong.

Do you know the function of a field in that location is?


Timothy

 

[pbaldy]

Not offhand. Looks like somebody needed the field on the report, but hid it and made it red so it would be noticeable in design view. Perhaps it's there for master/child links?

 

[Timothy Andrepont]

Paul,

Thanks

Timothy

 

[pbaldy]

No problem Timothy.