Passing forms values to a report

[Guest]

Hi All,

I have a calculated field qoh = sum(Units*type) in my main form. I have
combobox on my mainform which has the ID and Itemno. When i click the Itemno
the corresponding values are displayed in the childform. I am able to receive
or issue that item and the QOH gets calculated.
Question:

How can i display this on a report for each item.

My table :

ItemMaster
ID-PK - autonumber
Itemno-text
ItemDescription
Stockno
Location

Transaction:
TranID-PK - autonumber
ItemID-FK same as ItemMaster
Units
Type

Can i refer the text feild were the qoh is calculated on a report.

thanks in advance.

 

[Marshall Barton]

I have a calculated field qoh = sum(Units*type) in my main form. I have
combobox on my mainform which has the ID and Itemno. When i click the Itemno
the corresponding values are displayed in the childform. I am able to receive
or issue that item and the QOH gets calculated.
Question:

How can i display this on a report for each item.

My table :

ItemMaster
ID-PK - autonumber
Itemno-text
ItemDescription
Stockno
Location

Transaction:
TranID-PK - autonumber
ItemID-FK same as ItemMaster
Units
Type

Can i refer the text feild were the qoh is calculated on a report.

Just use a text box expression like:
=Forms!theform.thetextbox

BUT, that imposes a dependency on the report. It would be
better if you could create a query that calculates the sum
so the report wouldn't care if the report is open or not.
OTOH, maybe your report has other dependencies and
elimination just one of them won't make a difference.