View Single Post
  #2  
Old May 27th, 2010, 04:48 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Friendly Report Names

Steve wrote:

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 & """"


Right, exept the code should be:

DoCmd.OpenReport Me!NameOfListBox

--
Marsh
MVP [MS Access]