Hi,
I came across this problem qnd until now i do not find no solution.
There is a table stock and table invoice,a form Invoice and two button save and update On the table stock there is productId and productName and productprice.
The invoice table has InvoiceNumber,productId(For the relationship) and product name.
Me.Modifiable13 is a combo box containing the productId,productPrice and productQuantity.
On the invoice form i do not display the productId,Me.Modifiable13 display a name. But while updating the table and saving,the value of productname is a number and on productId there is a zero.
Help please i have tried everything i know
Codes
strSQL = "UPDATE Stock Set [produitQuantite] = " & Me.Texte15 & " WHERE [produitId] = " & Me.Modifiable13
CurrentDb.Execute strSQL, dbFailOnError
Me.Texte15 = ""
Me.Texte17 = ""
Me.Texte19 = ""
REGARDS