Report from list box

[jclaydon]

I am trying to open a report, filtered by the selection in a list box. Have tried various solutions to similar problems posted on the forum, but am still having no joy.

Have placed an open report button on the form, which have coded:

Dim stDocName As String
Dim where As String

stDocName = "Leaflets"
where = "[6th_Form_Prospectus_Title] = " & Me.lsttitle.Column(0)

DoCmd.OpenReport stDocName, acPreview, , where

But doesn't work. Any ideas?

Thanks

 

[jclaydon]

Solved it with some help from Len (on Form Forum).