Code To Use At Form And Report

[Ashfaque]

Hello,

I have some working code in a Sub xxx() for the graph that placed on a form. This code was used for chart.
The same chart I have placed on the report to send it concerned authorities in pdf.

The graph in report is ok but some calculated figures which are appearing in the form are not appearing in the report. Those calculated figures will appear surely in the report also if I copy code lines of form and place in report events. The thing is code is lenthy and dont want to make my report heavy.

So my question is how to place my code in a public module and just call it on form and report. so this way I can copy same code lines at form and report.

I haven't yet placed my own created code in a Public module so need your support.

Thanks,

 

[theDBguy]

Just create a Standard Module and start with something like:

Public Function FunctionName() As Variant
'your code in here
End Function

You can then call your function from anywhere.