Make reference to controls on a report

G

Guest

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.


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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top