Print Many Shipping Labels 1

[jdaryl2003]

I created an invoicing program for a wholesale industry. What I am trying to achieve is to print shipping labels by selecting one address from a list of many ship to addresses. One billing customer may have as many as twenty five ships to addresses. The following is what I have accomplished to this point. I have a dialog form with a list box to enter customer ID. By pressing the go button a query runs that opens a continuous form viewing all ship to addresses for that customer. All ship to addresses uses the same ID as billing customer. What I would like to do next is give focus to one address, click on that address and open another form displaying that address only. I also want a box on that form to enter label quantities. Finally a button is pressed to print labels.

Thanks for your help.

 

[PaulBricker]

If you add a button to your continuous form, you can put the code you need behind the click event. It would look something like this

Private Sub Command15_Click()
Dim myCompany as String, myAddress as String
Dim myForm as String
myForm = Forms!NewFormName
myCompany = Me.CompanyName
myAddress = Me.Address
DoCmd.OpenForm  myForm,  acNormal, "myForm!CompanyName = '" & myCompany & "' And myForm!Address = '" & myAddress & "'"

End Sub

Then when they click the button in the correct record, they will pass the correct values to the new form.

Paul