468,110 Members | 1,899 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,110 developers. It's quick & easy.

report title based on form filter

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!
Jul 25 '06 #1
1 2722
comteck
179 100+
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
Jul 25 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Johan | last post: by
3 posts views Thread by Jorge Cecílio | last post: by
reply views Thread by Rahul Chatterjee | last post: by
5 posts views Thread by Andrew Meador | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.