Hi,
I have code below that is used to add a new number to the txtTracking Field
based on what the user puts into the text box (txtTracking). What I would
like it to do is add whatever is already in the OnHand field, to what the
user has put into the txtTracking text box, to replace the number in OnHand
So ... OnHand = 20, user inputs 15 and the event is run, OnHand value is now
35
Any help would be greatly appreciated, thank you.
Private Sub cmdOK_Click()
Dim strsql As String
CurrentDb.Execute "Update tblStock Set OnHand = """ & Me.txtTracking & """
Where SKU = " & Me.txtOrderNumber & ";", dbfailonerror
Me.StatusListBox.AddItem "STOCK # " & Me.txtOrderNumber & " MARKED DOWN QTY
OF " & Me.txtTracking & "", 0
txtOrderNumber.SetFocus
End Sub
--
Kind Regards,
Customer Services,
Blue Lagoon Products
http://www.fastminimoto.co.uk
P.S. For us to answer your emails efficiently, please always include the
original message. Thank you.