form help

[Guest]

I have a report from a query with the parameter for the query asks [Enter
User Name] How do I get the Performance text box to input the parameter for
the text once the report is run? This is what I have thus far, it also have
other data being pulled from the query and they work fine. Can some one help
me.

="Performance Information
" & [Enter a User Name] & " " for the period between " & [Enter a Start
Date] & " and " & [Enter an End Date]
Thank you in advance.

 

[fredg]

I have a report from a query with the parameter for the query asks [Enter
User Name] How do I get the Performance text box to input the parameter for
the text once the report is run? This is what I have thus far, it also have
other data being pulled from the query and they work fine. Can some one help
me.

="Performance Information
" & [Enter a User Name] & " " for the period between " & [Enter a Start
Date] & " and " & [Enter an End Date]
Thank you in advance.

It looks OK to me ... except ... for the fact that the bracketed text
in the query prompt ([Enter User Name]) is not the same as the
bracketed text in the report text control's control source
([Enter a User Name]). The 2 must be identical

 

[Guest]

Thank you fredg, it worked you are wonderful. A second pair of eyes helped.

I have a report from a query with the parameter for the query asks [Enter
User Name] How do I get the Performance text box to input the parameter for
the text once the report is run? This is what I have thus far, it also have
other data being pulled from the query and they work fine. Can some one help
me.

="Performance Information
" & [Enter a User Name] & " " for the period between " & [Enter a Start
Date] & " and " & [Enter an End Date]
Thank you in advance.

It looks OK to me ... except ... for the fact that the bracketed text
in the query prompt ([Enter User Name]) is not the same as the
bracketed text in the report text control's control source
([Enter a User Name]). The 2 must be identical