How do I get value from VB textbox to report textbox

[pelagic]

Hi All,
on the VB form I have a text box named txtName.text
on the Access report I have also have a textbox name
txtReportName

How do I get value from vb textbox (txtName) to Access report textbox (txtReportName) when I print the the report?

Any idea will help
Thanks,

 

[dhookom]

I would place the value from the VB form.txtName.txt into a table and include the table in the report's record source.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[PaulG111]

Hi pelagic,

Another way to do this is to place an unbound textbox in the header of the report and reference the textbox on the form directly. This will work fine as long as the form with your textbox on it is open at the time the report is printed or previewed. So for a textbox called txtName on a form called frmSample you would set the Control Source property of your unbound textbox in the report header as follows:-
=[Forms]![frmSample]![txtName]

Hope this helps. Regards, PaulG

 

[PaulG111]

Hi pelagic,

Just re-read your question. Only PROPERLY this time! My answer only works for an Access form of course. It looks like you are trying to pass a value from a VB form which I don't have a clue about! Sorry for wasting your time mate!

Regards, PaulG