reference a subform to a report

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.
lallentxAsked:
Who is Participating?
 
pique_techConnect With a Mentor Commented:
=forms!formName!subformName.Form!fieldName
                                             ^^^^^
You have to "tell" Access that you want to refer to something of the subform AS A FORM, which requires the one additional little tid-bit.

Hope this helps.
0
 
lallentxAuthor Commented:
thanks pique tech, such a little thing can make such a big difference.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.