Report data disappears when printed

[Tieval]

Arnel sorted this for me the other day.

The load event is not used for creating a PDF, you need to create the functions and bind them as the control source of the text boxes - control source =ELookUp().

If you have an on load event of txtbox25.Value = ELookUp() it will not work as it doesn't really load.

 

[kpstrat35]

I had some other problems with my previous solution because of timing. I've totally abandoned the subreport idea. It's been a bit of a pain but it works. I've just grouped the different sections using the Tag of the controls and set visibility based on that.

I never thought the Load Event wouldn't translate to the print but it doesn't.

 

[sneuberg]

I never thought the Load Event wouldn't translate to the print but it doesn't.

What really bugs me is that it shows up ok in the print preview. It's like we are being lied to.