Value from form to Report prompt

[snipered]

Hi,

Is there anyway to pass a value from a textbox on a form to the report that prompts the user (and auto-submits if possible).

So i have a textbox called txtID with value 23

When i press a button, the report opens up and 23 is shown in the prompt.

Thanks in advance.

 

[pbaldy]

A textbox with a control source of

=Forms!FormName.TextBoxName

would display the value on the report.

 

[snipered]

A textbox with a control source of

=Forms!FormName.TextBoxName

would display the value on the report.

Thanks, worked a charm. Seemed so much more complicated before.