Whoops. Small typo OpenReport not OpemReport. Also the quote marks are not
needed and will lead to an error when Access looks for a report named
"MyCrypticReportName" (including the quote marks)instead of
MyCrypticReportName with no extraneous quote marks.
To immediately print the report
DoCmd.OpenReport Me.[NameOfListbox], acViewNormal
or to open the report in preview mode
DoCmd.OpenReport Me.[NameOfListbox], acViewPreview
John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
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 & """"
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