>I recently discovered how to pass parameters between forms instead of using public variables. Is it possible to do the same to pass parameters to reports?
>
>I am trying to reuse the same report instead of creating multiple reports. In the past, I've used public variables. Should I continue to use public variables or is there a better way? I need to change the Group Footer based upon which report the user selected.
>
>TIA!
Public variables are not necessary at all, e.g.
**** some event, e.g. cmdRunreport.Click
Local nRptchoice
nRptchoice=thisform.ogChoice.value && some user choice from a form
REPORT FORM myreport && you can use nRptchoice inside the report form
Edward Pikman
Independent Consultant