Mailing Label

[Guest]

I have an Invoice Form with a mailing address on it (made up of a series of
text box's). I have a button on this form labeled "Print Mailing Label".
How do I get this to print a label On Click.

Steve

 

[Arvin Meyer [MVP]]

You can open a report based upon the ID of the record with the data you
want:

DoCmd.OpenReport "rptMailingLabel",,,"ID=" & Me.IDValue

or you can open a report, and in the report's open event, pass the values
from the form (aircode):

Sub Report_Open()
Me.txtName = Forms!frmWhatever!txtName
Me.txtAddress = Forms!frmWhatever!txtAddress
Me.txtCityStateZip = Forms!frmWhatever!txtCity & ", " & _
Forms!frmWhatever!txtState & " " & _
Forms!frmWhatever!txtZip
End Sub

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "PrintOneLabel.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L