VBA and reports

[netscamp]

I have a text box in a form, whose contents are calculated in a VBA module.

The same form has a button to print a report.

I want the button to fire some code that feeds a text box in the report with a value in a text box in the form.

How to refer to the textboxes in the code ?

Thanks a million!

 

[GKProgrammer]

Hi netscamp,

By the sounds of it the form will obviously have to be open when the report is previewed(printed), if this is the case then you can set the value of the textbox in the report.

Set the report's textboxes control source to something like the following:

=[Forms]![frmYourFormName]![txtFormsTextBoxName]

This should do it for you.


Regards,
gkprogrammer