Simple Problem Driving me maD! Plz Help :)

[Rixx]

Hi there,

I am new to this forum and am currently a Degree Undergraduate. I need help on what I think is a simple problem!

I am creating a stock control system. My problem to put it bluntly is Updating the Stock Table. In other words:

1.Quanity of items being bought is entered in the Order Form (e.g.2 Pens)
2.Product Table shows that there are 10 items in stock.

= I want it to show as "8 PENS" after the form is closed!! Please Help!!

ALTERNATIVELY I have created a query that performs the calculation, my simple question is...


I want to take the value from the query and put it in the 'current items in stock place'! How do I do this?

e.g I have got the query to work out that its 8 pens left. But I dont know how to replace this value in the place of the current value in the Products.ItemsinStock table.

Please Help

 

[gecko_1]

"UPDATE ProductTbl SET stockLeft = " & yourNewValue & " WHERE productID = " & theProductID

Could you place that sql statement in a module or form at the point where you need to update the value.

 

[modest]

"UPDATE ProductTbl SET stockLeft = '" & yourNewValue & "' WHERE productID = '" & theProductID & "';"

Don't forget the inner quotes