Southerndiva
IS-IT--Management
I have written a generic function which is being called from many reports. It concatenates the values of certain fields depending on the value of check boxes. i have created an unbound textbox on the report and its control source = fldvalu()
the first line of the function goes like this
function fldvalu() as string
if reports!rptname!chkfld = -1 then
fldvalu = "some thing;"
endif
if reports!rptname!chkfld2 = -1 then
fldvalu = fldvalu &"something2;"
endif
you get my drift. note that i have hard coded the report name. i need not to hard code the report name, so that the function can be called from any report.
should be simple. but where and how do i do it?
thanks in advance.
the first line of the function goes like this
function fldvalu() as string
if reports!rptname!chkfld = -1 then
fldvalu = "some thing;"
endif
if reports!rptname!chkfld2 = -1 then
fldvalu = fldvalu &"something2;"
endif
you get my drift. note that i have hard coded the report name. i need not to hard code the report name, so that the function can be called from any report.
should be simple. but where and how do i do it?
thanks in advance.