Using data from an unbound control on a form when printing a report

[Karen]

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

Then I have a table that's a list of ingredients (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

 

[Lynn Trapp]

Have your unbound control on the report reference the batch size control on
the form. This assumes that the form will be open when you run the report.