Forms and Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a form that has a few unbound text boxes that are used to enter
information such as Purchase Order number, quantities and descriptions. My
question is, when I am done entering the data into the form and I save it as
a report, I lose everthing that I manually entered. Is there a way to carry
that information onto the report?

Thanks for your help.
Kristin
 
If the form remains open, you can pull that data to the report.

Once the form is closed, unbound data is lost. That is the nature of an
unbound field.

Rick B
 
Hi,

I have a form that has a few unbound text boxes that are used to enter
information such as Purchase Order number, quantities and descriptions. My
question is, when I am done entering the data into the form and I save it as
a report, I lose everthing that I manually entered. Is there a way to carry
that information onto the report?

Thanks for your help.
Kristin
Click to expand...

Because your data is unbound, you need to refer to the form controls
from unbound controls on the report.
In your report, add an unbound control.
Set it's control source to:
=forms!FormName!ControlName
or...
= "Invoice Number " & forms!FormName!ControlName

The Form MUST be open when the report is run.
You can close the form, if you wish, when the report closes.
All the unbound data in the form will be lost.
Code the Report Close event:
DoCmd.Close acForm, "FormName"
 
Back
Top