How to return a value from VBA to Report

[mikejohn]

Hi,

I have created a Form in VBA and when I refresh my report it will ask the user to enter a input value, which has to be utilised in the criteria of the report. Please suggest the way to do this.

Regards,
Mike

 

[blom0344]

Hello Mike,

Check out the library section of the following site:

http://www.islink.com

I think there is an interesting example of what you are looking for. T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[FunkMaster]

Hi

check out my thread which i had the same problem

thread393-327595

that should sort things out

Funk Master

 

[mikejohn]

Hi Blom,

The above mentioned site is more informative and I got the solution.

Thanks a lot...

Regards,
Mike