ControlSource

[accessman2]

Hi,

I create the report, I place the subform on the Report header, and place the regular source attached the report, I make the textbox on the Report footer, and I put
=Forms![Invoices]!Amount - Sum([DiscountAmount])
on the Control Source of the textbox

Forms![Invoices]!Amount doesn't work. How do I present that value?

 

[namliam]

IIRC you cannot place forms on reports??!!

 

[accessman2]

How about subreport?

If I place subreport, then how do I represent the value of the subreport?

Reports![Invoices]!Amount

 

[namliam]

I guess you would.. but why do it that way?? The whole point of a subreport is to show data, why try to transport it like this if you can simply show the subreport?