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
Karen - 25 May 2004 20:17 GMT
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]
> I have a table that is the item master (code,desc,desc2,)
>
[quoted text clipped - 13 lines]
>
> Karen