print a form field's control source on a report

G

geebee

hi,

Does anyone know how to print a form fields control source on a report?

Thanks in advance,
geebee
 
F

fredg

hi,

Does anyone know how to print a form fields control source on a report?

Thanks in advance,
geebee
Click to expand...

Is the form open while the report is being run?
As control source of an unbound control in the report:
=forms!FormName!ControlName.ControlSource

If the form is not open when the report is run, code the Format event
of section that the report control is placed in:

DoCmd.OpenForm "FormName", acDesign, , , , acHidden
Me![ControlNameonReport= forms!FormName!ControlName.ControlSource
DoCmd.Close acForm, "FormName"
 
Top