> This is code from the page that is working. As you can see there is not a
> field called subReport_Customer_Contact
> So what does that have to do with it if this code works?
Sorry, I'm totally lost, have no idea what you're talking about. Let me
start from scratch.
Your code contains this:
The intent of this line is to assign a subreport to the Subreport property
of the report field "SubRouting".
However, the report doesn't seem to contain a field called "Subrouting", so
you get the error.
This has nothing to do with your Sql statements etc. It has to do with the
report definition itself. I suggested you inspect the field names using the
code posted earlier, to confirm that the report doesn't really contain that
field. Another option would be to look at the report definition (in
Looking again at the code you posted earlier:
vsrSub.Load "c:testwebwebSolutionsreportsWorkOrder2.xml", "subRouting"
vsrSub.DataSource.RecordSource = strSQL_Routing
It looks like "subRouting" is the name of a report, not a field.