Recordsource fields in a report

[Björn]

Hi

Can anyone tell me how I can retrieve value from a field in a form
recordsource if the field is not in the report.

The only way I've done it is by adding the field to the report and made it
invisible. Then I can access the value from the report code.

There must be another way????

Best Regards,
Björn

 

[Marshall Barton]

Can anyone tell me how I can retrieve value from a field in a form
recordsource if the field is not in the report.

The only way I've done it is by adding the field to the report and made it
invisible. Then I can access the value from the report code.

There must be another way????

Assuming you meant report record source instead of "form
recordsource", no, there is no other way. It's an Access
optimization where Reports do not waste time retrieving a
field from their record source if there is no control bound
to the field.