View Single Post
  #3  
Old May 27th, 2010, 05:05 PM posted to microsoft.public.access.reports
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default Friendly Report Names

Build a table of report names:
TblReportName
CryticName
UserFriendlyName

Make this table the Rowsource of your listbox. Set the Bound Column = 1,
Column Count = 2 and Column Width = 0, 3. The listbox will display the user
friendly names but the selected report will return the cryptic name. Put the
following code in the AfterUpdate event of the listbox:
DoCmd.OpemReport """" & Me!NameOfListBox & """"

Steve



"gchichester via AccessMonster.com" u46492@uwe wrote in message
news:a8a2d00621643@uwe...
I have 40+ reports with somewhat critic names that would confuse my users,
Is
there a way to assign
a alias/friendly name to the reports and use it to call the report from a
listbox?

Thank you for any and all suggestions
Gil

--
Message posted via
http://www.accessmonster.com