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]
|