Changing Report from outside ?

[Stuart Crow]

Hello
I am at present working on an app written in Access 2002 which
contains a few reports. The app is to be extended, and I would like to
be able to reuse these reports. There is no problem with changing the
query to get the data using Me.Properties("RecordSource").Value on
report_open. To reuse the reports, though, I need to change a text
field within the report, ie. there is a text field called txtHeading
which has a text string in it, and in the properties for this
txtHeading there is ControlSource="...." - the text string.
Is it possible to change the text in this txtHeading on report_open ?
Or if not, is there any way that this can be done ?
TIA
Stuart

 

[Brendan Reynolds]

I'm not sure what you mean in your subject line by 'from outside', but if,
as seems to be the case from the body of the question, you want to do this
from the Open event procedure of the report, then yes, that can certainly be
done ...

Private Sub Report_Open(Cancel As Integer)

Me!Text2.ControlSource = "='Hello World!'"

End Sub

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Stuart Crow]

Thanks a lot, that works fine !
Stuart