How do i print from a listbox?? i'm using Access.
Here's my code for the form to add items to the listbox... I have tried many ways and have failed many times ... Help needed!!
Option Explicit
Dim ItemNumber As String
Dim ItemDescription As String
Dim Qtytoorder As String
Dim AmmendPrice As Currency
Private Sub cmdAdd_Click()
ItemNumber = ITEM_NUMBER.Value
ItemDescription = ITEM_DESCRIPTION_1.Value
AmmendPrice = txtAmmendPrice.Value
Qtytoorder = txtqtytoorder.Value
With lstReorder
.AddItem ItemDescription & " " & ItemNumber & " " & Qtytoorder & " " & AmmendPrice
End With
End Sub
I want to print to a printer please :) so i have a hard copy to scribble on etc.
any help is muc appreciated :)
michael