Printing Label from Form

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

Guest

Hello all, and thank in advance.

I'm wanting to print a label from access. The date is only on a form, not
in a table. I made a form with the needed fields and then made a report with
the layout I need. How do I pass the fields from the form to populate the
data needed on the report?

I tried this, but does not work

vbank = bank
DoCmd.OpenReport "BoxlabelStock", acNormal, "", ""
 
Hello all, and thank in advance.

I'm wanting to print a label from access. The date is only on a form, not
in a table. I made a form with the needed fields and then made a report with
the layout I need. How do I pass the fields from the form to populate the
data needed on the report?

I tried this, but does not work

vbank = bank
DoCmd.OpenReport "BoxlabelStock", acNormal, "", ""
Click to expand...

What is
vbank = bank
all about?

If you don't have the data in a table, then you need to design your
report with unbound text controls referencing the controls on the
form.

=forms!FormName!ControlName1
=forms!FormName!ControlName2
etc.

Code the Form's command button click event:
DoCmd.OpeReport ""BoxLabelStock"

The form must remain open when the report is run.
 
Back
Top