J
jer99 via AccessMonster.com
I have set up a table called Report_Driver that contains:
ReportName
ReportField
FieldValue
FieldSource
FieldType (can be "Literal" or "Field")
I have set up a few text fields in the report.
My intent is call a function from the report that will exist in a module. It
will do something like this:
open the Report_Driver for a specific reportname
Go through the records
If the field exists then <<<<<-
----**************
if the type is literal, place the value in the caption of the
text box
if not, then do a query, make a literal from the result to place
in a text box
endif
How do I find if the field exists?
and how do I reference it to set the caption from the module function?
It doesn't like:
reports(sreportname)!(sfieldname).caption = RsTemp!FieldValue
(where I populated sreportname with the report name and sfieldname with the
field name from the table)
For some reason I'm just not seeing it.
ReportName
ReportField
FieldValue
FieldSource
FieldType (can be "Literal" or "Field")
I have set up a few text fields in the report.
My intent is call a function from the report that will exist in a module. It
will do something like this:
open the Report_Driver for a specific reportname
Go through the records
If the field exists then <<<<<-
----**************
if the type is literal, place the value in the caption of the
text box
if not, then do a query, make a literal from the result to place
in a text box
endif
How do I find if the field exists?
and how do I reference it to set the caption from the module function?
It doesn't like:
reports(sreportname)!(sfieldname).caption = RsTemp!FieldValue
(where I populated sreportname with the report name and sfieldname with the
field name from the table)
For some reason I'm just not seeing it.