use data entered in unbound controls (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 (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
 
K

Karen

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top