programatically read closed form/report caption

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Nick X said:
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
Click to expand...


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.
 
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.
 
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.
 
Back
Top