From forms to Report

A

Alex Ng

Hi,

I've created a form with lots of unbound textboxes where they display
results of calculations after hitting a command button (with a lot of code
behind it.)

Is there a way to "transfer" all the values within the text boxes onto the
report for printing??

Thanx,
Alex
 
F

Fredg

Alex,
One way is to have an unbound control on the report for each unbound control
in the form that has a calculation.
Set the Control source of each control to:
=forms!FormName!ControlName

The form must be open when the report is run.
 

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

Similar Threads

Automatically name a report when exporting to PDF 1
access report 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Upgraded from Win 7 to Win 10. Publisher printing black. 1
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
A03 - count in report footer gives me #Error? 0
Problem Filtering Report data 1
Changing text color and textbox color on Access Report 1

Top