reference a subform to a report
Posted on 2004-09-28
I have a report which displays fields from a form and a subform. the data displayed in the form/subform(master/child) are the source of the report.
My form is bound but my report is unbound.
The fields in the report reference the fields in the form like this =forms!formname!fielName
this works great when the report field source is the master form form displaying the correct values in the report however, it does not work for the report fields depending on the child form(subform). the report fields based on the subreport display #name?.
in the report, the fields based on the subform I have tried =forms!subformname!fieldName. I have also tried =forms!formName!subformName!fieldName. either way these fields do not display the expected value instead they dispaly #Name?
does anyone know the syntax to make this work?
I hope I'm explaining my problem enough for you to help me, if not ask me questions.