Pardon me for jumping in, I have an identical problem. I
need to show a certain string in the page footer. The
string is the same for all pages in the report, but may
change over the years. Sort of a configuration parameter,
e.g. Name of the Company Issuing this Invoice. I have the
string value in VBA, just don't know how to apply it.
First, I've tried fiddling with the Recordset, but there
was no way to feed it back into the Report (btw, Jamie, if
you define your underlying query as "snapshot" instead of
the default "dynaset", then the result set won;t attempt
to apply changes back into the database).
Next, I have tried placing an unbound control in the
footer band, then then settings its Text property in VBA,
in the Open. An error came back, saying I'm not allowed to
do that. Perhaps I was using the wrong event ?
Anyway, I can see many people are wondering how to change
data programmatically in a Report. Let's hope our beloved
vendor comes out with an improved version, of either Acces
or the documentation.
Meanwhile, my workaround was to join my query with a table
containing the constant string.
Andrew
