Module Reference for Version Control

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I'd like to place a version control statement on all
reports of a database being controlled from a central
location.

I've created a module with the function VersionWrite. Each
report calls this function, which generates the string
(e.g. v1.1.1) which will be displayed at the bottom of the
report.

The VersionWrite function works fine, the problem I have
is passing the value back to the report to change the
value of the unbound control.

I've tried 2 ways of doing this, but can't get it to work.

1) pass the string generated from the function
VersionWrite back to the report and set the value of the
unbound control

PROBLEM WITH 1) 1) How do I pass the value back to the
report? I'm just getting a null string back

2) pass the name of the opened report to the function and
change the value of the control from the function.

PROBLEM WITH 2) I can pass the reports name to the
function using the string myOpenReport, but when referring
to the report in VBA Reports!myOpenReport.VersionControl
to set the value I get a myOpenReport is not a valid
report. How do I reference the report using a string?

Any help will be much appreciated
 
You should just be able to set the ControlSource property of the unbound
textbox to:

=VersionWrite()

HTH,
TC
 
Back
Top