Passing a text

B

bladelock

Hello all,

I have a form that I type a text "Dim txtSearchString As Variant" which find
the person i'm looking for. Works fine, just one problem. I would like to
print the name I typed on my form on the report that print after I searched
this person. How can I get to transfer this name the user typed in the box on
my form to the report?

I try just placing a text box on the report named: "txtSearchString" but
when the report runs, a dialog box ask me what "txtSearchString" is.

Any suggestions?

Thanks
 
D

Duane Hookom

If the form is open and the value is available in the text box, you can use
a control source of:
=Forms!frmYourFormName!txtYourTextBoxName
 
B

bladelock

I tried that I entered"=Forms!formSerachDoctor!txtLastName" and when I click
the print button I can a dialog box Enter Parameter Value
"=Forms!formSerachDoctor!txtLastName" I know I'm doing something wrong
 
K

Ken Snell [MVP]

By chance, is this a typo?
Forms!formSerachDoctor!txtLastName

perhaps it should be
Forms!formSearchDoctor!txtLastName
 
Top