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

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 (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
 
L

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