Reports title from List box selection

G

gumby

I have a report that is filtered by a list box selection. I would like
the selection to show up in the report title auto populate.

With Reports![rptRMC Department_Custom_HR_Status]
.Filter = strFilter
.FilterOn = True
.txtReportTitle.Value = _
"RMC Staffing Report - " & Format(Date, "dd mmm yyyy") _
& vbCrLf & "Department: " &
[Forms]![frmReportFilterRMC]![lstDepartment]

End With

I have also tried & vbCrLf & "Department: " & strDepartment (This
shows the selected item as a filter statement. "IN (HR)"

This works fine if I use a combo box, but I would like to use a
listbox.

David
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automate the Report's Title 1
Unable to display values in 2nd list box from 1st list box selection 2
List box for reports 1
Error 3085: Undefined function 'N' in expression. - Access 2010 1
Categorize Reports 2
How to run a report from chosing an item form a combo box 5
Filter Subreports from Form OnClick with VBA 1
Filter report from combo box to list box 1

Top