form help

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

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
 
Thank you fredg, it worked you are wonderful. A second pair of eyes helped.

fredg said:
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.
Click to expand...

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
Click to expand...
 
Back
Top