How to create Report with dynamic title

[furnitureheaven]

Hi
I am currently building a report. I have one reports, and one form with 3 buttons to generate 3 reports, I just want to create one report with 3 different titles against each button. (e.g if user click on button 1 then title should be Button 1 and if they click on button 2 then title should be Button 2 and so on). I have built 3 quires for 3 buttons button.

2nd on the Parameter window (little popup window) how I can change “Please enter Open Date” and different on others.

My knowledge is very limited, but I think we can do the above. i have attach file for details.

Any help very much appreciated.

Furnitureheaven.

 

[RuralGuy]

See if this get you a little further along in the project.

 

[furnitureheaven]

See if this get you a little further along in the project.

Thats solved but i also asked, that i have 3 command buttons and 3 queries, i only have one report. i want if some one click on 'View By Open Date' button, then it should ask the parameter value from user and open the report against the parametter value on the report. same as on other command buttons.

i have tried but cannot successfull. i have searched some examples but those are with combo box, but not with command button. so could you help........

Thanks for above solution.

 

[RuralGuy]

Were you able to solve this problem?

 

[furnitureheaven]

Were you able to solve this problem?

Not Yet, i tried a vba coding, but on run time it won't accepting a record source, so i think we cannot define a record source on run time bases for report.

i might be wrong. because i don't have enough knowledge in Access.

 

[RuralGuy]

Give this db a try.

 

[furnitureheaven]

Hi,
Thanks, i have done this, and its working fine.

Thanks again for your help

 

[RuralGuy]

Glad I could help.