Printing 4x6 labels from a form

  • Thread starter Thread starter Joey1010
  • Start date Start date
J

Joey1010

I have created a form that will be used to track the location of pallets
within a warehouse. I have several fields on the form which will be written
to a table, but also need to be printed on a 4x6 label.
Can someone tell me how to capture the data within the fields on the form and
print it on the 4x6 label?

Thank you,

Joey
 
I have created a form that will be used
to track the location of pallets within a
warehouse. I have several fields on the
form which will be written to a table,
but also need to be printed on a 4x6
label. Can someone tell me how to
capture the data within the fields on
the form and print it on the 4x6 label?
Click to expand...

Use the unique identifier of the record (which should be available from, but
not necessarily visible on, the Form), with the DoCmd.OpenReport Command to
run the Report (in which you have cleverly included all the data from that
record that is needed for the label). Direct the output to the device on
which you wish to print the label.

Larry Linson
Microsoft Access MVP
 
Larry, Thanks for the help. I will try your suggestions and see where I get.


Joey

Larry said:
I have created a form that will be used
to track the location of pallets within a
Click to expand...
[quoted text clipped - 4 lines]
capture the data within the fields on
the form and print it on the 4x6 label?
Click to expand...

Use the unique identifier of the record (which should be available from, but
not necessarily visible on, the Form), with the DoCmd.OpenReport Command to
run the Report (in which you have cleverly included all the data from that
record that is needed for the label). Direct the output to the device on
which you wish to print the label.

Larry Linson
Microsoft Access MVP
Click to expand...
 
Back
Top