Here is what I'm trying to do:
I have a report that is using a query as its record source for some information to be populated in the report. I also have some additional report fields that will be populated by a data entry form that is unbound to a record source.
On my report design, I have the data from the record sourced query in there correct, but the data from the unbound form is not showing up right.
For example, in one of the unbound fields on the report I have the control source called out as "[forms]![MCLMCX_subform]![AddRmk]". The data entry unbound form is "MCLMCX_subform" and the unbound field on that form is "AddRmk". When I run my report I just get the "Name?" type error for all of the unbound fields.
Do I need to find a way to associate those unbound fields with a query/table? Oh and when I run the report, the unbound form is currently open and filled out so it should pass that info to the report right? Thanks.
I have a report that is using a query as its record source for some information to be populated in the report. I also have some additional report fields that will be populated by a data entry form that is unbound to a record source.
On my report design, I have the data from the record sourced query in there correct, but the data from the unbound form is not showing up right.
For example, in one of the unbound fields on the report I have the control source called out as "[forms]![MCLMCX_subform]![AddRmk]". The data entry unbound form is "MCLMCX_subform" and the unbound field on that form is "AddRmk". When I run my report I just get the "Name?" type error for all of the unbound fields.
Do I need to find a way to associate those unbound fields with a query/table? Oh and when I run the report, the unbound form is currently open and filled out so it should pass that info to the report right? Thanks.