Populating Report with Unbound Form Data

maytime

Registered User.
Local time
Today, 08:35
Joined
Apr 1, 2008
Messages
29
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.
 
Well my 'subform' is actually just a main form that is launched via a command button with additional fields to be filled out so it technically isn't a subform, I just have it named like that.
 
Have you tried

=forms!MCLMCX_subform.AddRmk
 
Wow, I can't believe I forgot to put in the "=" before each one of the fields linked to an unbound form control. It fixed it for sure. Thanks!
 

Users who are viewing this thread

Back
Top Bottom