| | |
|
|
|
Using data from an unbound control on a form when printing a report |
|---|
| message from Karen on 21 May 2004 |
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 replied to Karen on 21 May 2004 |
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.
|
|
Archived message: Using data from an unbound control on a form when printing a report (Microsoft Access Forms)
