Listbox to print a report 1

[Leventcos21]

I have an unbound listbox that lists 6 different types of reports. The rowsource is tblReports.

How can I go about select a specific report from the list and have it go to that report?

Thank you,

 

[Remou]

As in (?):

[tt]DoCmd.OpenReport Me.lstReports, acViewPreview[/tt]

 

[Leventcos21]

That I know how.

DoCmd.OpenReport Me.lstReports, acViewPreview

If the list has 6 reports displayed, I select row 3 "List employees" I want to print that specific report.

 

[Remou]

Does your list box have more than one column? What does:

MsgBox Me.NameOfListBox

Return? If it is not the name of the currently selected report, you can use the Column property to return the column that holds the name of the report. Columns start numbering from 0.