print data in the form and not the form

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

Guest

I have an unbound form that lists the results from the choices made from two
list boxes. I created a "Print Form" command button but it only prints the
form (the current screen) and not the data in the form. Please help me create
my report.
 
I have an unbound form that lists the results from the choices made from two
list boxes. I created a "Print Form" command button but it only prints the
form (the current screen) and not the data in the form. Please help me create
my report.
Click to expand...

That's your problem, you don't have a report and the form itself is
unbound..
Create a report with no record source.
Add as many unbouncd controls as you need.
Place them in the desired position.
Set the control source of each control to:
=forms!FormName!ControlName
using the appropriate control name for each control.
Add whatever labels you want.

Print this report.
 
That's your problem, you don't have a report and the form itself is
unbound..
Create a report with no record source.
Add as many unbouncd controls as you need.
Place them in the desired position.
Set the control source of each control to:
=forms!FormName!ControlName
using the appropriate control name for each control.
Add whatever labels you want.

Print this report.
Click to expand...

I forgot to add that the form must be open when the report is run.
 
I already created unbound text boxes and tried to put the controls but
somehow it doesn't show anything. The Results form gets its data from the
selection made from the list boxes.
 
Back
Top