Passing year parameter to subreport

[p7eggyc]

I am working with several subreports on a main report. I need to prompt the user for a year to use on all the subreports and I would also like to use that year in a textbox title. I have inserted the [Enter Year: ] prompt in the record source SQL for each subreport and in the control source for the textbox. The textbox is giving me an ?Name error and the subreports are generating the user input box for the year for each subreport. I would like to just have the user give that information once and provide it to all the subreports and the textbox. Any thoughts? Thanks!

Peggy

 

[ScottMusich]

It sound like you have it right - just to make sure, the [Enter Year: ] must be typed in exactly the same in all subreport queries/sql and textbox!

Does it ask you for year for EVERY subreport or just some of them - if it is just some of them then the above is probably true. Scott Musich
Database Analyst/Programmer

 

[p7eggyc]

I double checked to make sure they are the same and they keep coming up. I just read on another forum to use a form to get the user input instead of letting Access prompt. Have done that in another place in this app so I think that is what I'll do here. Thanks for the thoughts!

Peggy