ill sound stupid (1 Viewer)

tubar

Registered User.
Local time
Today, 15:43
Joined
Jul 13, 2006
Messages
190
i probably want to create a upddate querry or maybe some code but...

i have a light bulb and i keep 300 on hand i just ordered 300 more when i check the box that the order is complete i need the "bulb on hand" feild to update to 600....please help
 

wardster

Registered User.
Local time
Today, 20:43
Joined
May 25, 2006
Messages
34
as a starter:

UPDATE tbl_stock
SET quantity = quantity+[stock_to_add]
WHERE ProductID = ProductID_on_your_form

maybe worth adding the extra code that once tickbox is checked it then disables to prevent users from unticking and reticking > adding again to stock

Ian
 

Users who are viewing this thread

Top Bottom