Using data from an unbound control 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 (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
 
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.
 
Back
Top