Passing forms values to a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
vandy said:
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.
Click to expand...


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.
 
Back
Top