If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
use data entered in unbound controls (on a form) when printing a report
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 |
#2
|
|||
|
|||
use data entered in unbound controls (on a form) when printing a report
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] "Karen" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|