Make reference to controls on a report

C

clara

Hi there,

I want to assign my controls' value in a form to controls on a report, could
you tell me how to make the reference.

clara

thank you so much for your help
 
M

Marshall Barton

clara said:
I want to assign my controls' value in a form to controls on a report, could
you tell me how to make the reference.
Click to expand...


The report must "pull" the values from the form.

You can use the Format event of the report section that
contains the control:
Me.somereportcontrol = Forms!theform.someformcontrol

It's probably easier to just set the report control's
ControlSource to an expression:
=Forms!theform.someformcontrol
 
Top