use data entered in unbound controls (on a form) when printing a report

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

I have a table that is the item master (code,desc,desc2,)

Then I have a table that's a list of ingredients (code, rm#,
desc,desc2,amount,units).

On a form the user enters a code and a batch size. The query brings up the
ingredients and calculates the amount needed (ingredients.amount *
batchsize). Works great.

Now for the question...
I need to make a printed Prep sheet that shows the results of the above
query. I know how to design a report but how can I use the batchsize (an
unbound control) on the report to do the calculation?

Thanks,

Karen
 
i got it. on the report i made an unbound control that refers to the
control on the form. You can't close the form when printing (not a big deal
for me since the user needs to see the form immediately anyway). the
control source for the unbound control on the report is something like this:

[forms]![formname]![fldname]
 
Back
Top