I'm currently building on the Northwind Traders 2007 sample database to work for a home party plan consultant. The sample database includes an inventory list with a coded button to add the inventory item to a purchase order. I would like to have a separate button that would add all of the products to a single purchase order. Is this possible?
This is the coding behind the button:
Private Sub cmdPurchase_Click()
If Not Me![Qty To Reorder] > 0 Then
MsgBoxOKOnly NoNeedToRestock
ElseIf Inventory.RestockProduct(Me![Product ID]) Then
Me.Requery
MsgBoxOKOnly RestockSuccess
Else
MsgBoxOKOnly RestockingFailed
End If
End Sub
TIA - Ed