Input parameter in report header

[geremore]

Hi,

Newby question. Got a simple report from a query having a standard parameter (part of criteria). Is it possible to get the text typed in the header of a report? Something like:
Private Sub ReportHeader_Paint()
'Add the types text to the report header
Label123.Caption = ??? Paramater.text ???
End Sub
Thanks for any help!

Geremore

[boblarson]

Use an input form for your parameters and you can then just refer to them using a text box formatted as a label and with the control source of:

=[Forms]![InputFormNamHere]![ControlWithValueNameHere]

Using input forms instead of parameter prompts are much better anyway. See here for more about that:
http://www.tek-tips.com/faqs.cfm?fid=6763

[geremore]

Thanks Bob,
One more question: in that case: how to pass the typed value to the query?
Thanks for yout help!
Geremore

[boblarson]

The query's criteria would be

[Forms]![InputFormNamHere]![ControlWithValueNameHere]

normally. It really does depend on what the criteria is for (date range, text value, whatever) that determines how you put it in there.