Passing a text

G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top