Can you add programmed items to reports?

[munger]

I worked hard and managed to get some important values calculated in code. Now I want to make a report and add these values to text boxes in the report.

Like: txtPlan.value=lngChardonnayPlan

I have not succeeded and I suspect that I don't know where to put the event procedure.

Thank you all for thinking...

Munger

 

[shannonp]

How about putting it in your Reports 'On Open' event?

 

[munger]

I tried that and it didn't work at all.

I put the code in On Open with ' msgbox lngChardonnay ' and after that the line that should put it into the text box: txtPlan.value=lngChardonnay but nothing happens and the report comes without it.

 

[CosmoKramer]

Or in the On Format event of the section where your text boxes are.

 

[shannonp]

Hmmmmm, strange? How big is your database?...could you e-mail me a copy of your MDB file so I can have a look?

Shannon.Patangata@treetech.co.nz