Subform Field Linker error: Obj Variable or With block variable not set

[dmsmythe]

I am creating a 2 level report to confirm an order. Main report already created, runs successfully called as subform/subreport under "OrderDetails" form. Linked to master using Order.ID. There are two versions of the confirmation report that have different layouts for different program types.

The hangup comes when I try to add a "Class Dates" subreport. It lists dates of individual classes and Skip dates. I have created the subreport as "srClassDates". When I add it to the main report, it lists the records. However, when I try to link it to the Main report, an error message box appears with the "object variable or With block variable not set".

I have tried rebuilding both the main and subreports, rebuilt the query, have not found anything that changes the result.

Linker has been working successfully on other subforms. Report with groupings works fine, but I need data from 2 tables both linked to order.id.

 

[dmsmythe]

posting zipped copy of the db.

 

[dmsmythe]

Re: Subform Field Linker error: partially solved

I had been editing the subreport directly in the Form Design where it was embedded. I opened the report separately, then added the subreport and the linker did not error out.

The report runs with no problem when I go to report view. When I open the Form it is embedded in, I get prompted for "Order" value unless I delete the subreports from the report.

I have deleted, reinserted and relinked in each combination possible. The prompt happens if either subreport is included in the main report, but only when opened as a subreport within the form.

I'm sure the reference is not correct, but can't figure out how to change it.