report title based on form filter

[mpmason14]

how can i create the title for my report based on the filtered criteria in a form? the form opens the report and i want the report to have the title of what was filtered.

the user can filter among many things (usually only one, though) on the form, and i would like to get whatever was filtered on the report as the title

i have the basics down, like having an unbound text box and having =[filter] in there to show what is being filtered, but i want to display it in a more presentable and readable fashion.

for example, i would get this: "(((proposal.KEY_PERSON="Test"))) and instead i want it to display as "KEYPERSON=TEST" (without the parentheses and preceding 'proposal')

any help appreciated!

[comteck]

Are you assigning the filter to a variable? If you are then in the "On Open" property of the report, start an event procedure and include this text:

Me.Labelname=variablename

If you want the name to change on the click of a button, then put this text on the "On Click" procedure of the button instead. If the variablename comes from a different form, then you may have to refer to the form.

If this doesn't work, then could you provide more detail (i.e is the report created on the click of a button from a form?).

comteck