programatically read closed form/report caption

[Guest]

Hi all,
Can this be done? I have a combo box on a form that is set to the "Name"
field of the sysobjects table. I use it to select a report to open. I would
like the combo box to display the caption or something less db'ish than the
actual object name

Thanks in advance,
NickX

 

[Marshall Barton]

Can this be done? I have a combo box on a form that is set to the "Name"
field of the sysobjects table. I use it to select a report to open. I would
like the combo box to display the caption or something less db'ish than the
actual object name

How about creating your own table of reports? It could
contain 3 fields:

ReportName - Actual name or report
Abbrev - short version of name for users
Descr - description of report for newer users

This way you can avoid the possibility of a user selecting
some test report or a subreport that they have no business
opening.

 

[Guest]

Thanks for the response, I like that idea. Of course, I could never let it
be that simple. I think i will build a little Admin Control Panel form that
I can use to "Push" the report name into the table from the sysobjects, as
well as, some text boxes for additional information.

 

[Marshall Barton]

Yes, an admin form to manage the list of reports is a nice
idea. You are bound to have more reports in the future and
will probably want to modify the description text.

I think I would prepopulate the table from the MSysObjects
table and leave that kind of thing out of the form.