Addition in an update query

[aggiematt]

I am trying to make a form that adds and subtracts from a table using an update query.
My current query is
UPDATE (TABLENAME) SET TABLENAME.Quantity = TABLENAME.Quantity + !FORMS!FORMNAME!CONTROLNAME
WHERE TABLENAME.FIELDNAME = FORMS!FORMNAME!CONTROLFIELDNAME
Sometimes it adds sometimes it doesnt sometime it just replace the value in the table with the quantity input.
When suctraction is used in the same query nothing happens.

 

[KenReay]

Hi

maybe its just a tupo in the post, but:

UPDATE (TABLENAME) SET TABLENAME.Quantity = TABLENAME.Quantity + !FORMS!FORMNAME!CONTROLNAME
WHERE TABLENAME.FIELDNAME = FORMS!FORMNAME!CONTROLFIELDNAME

you have a surplus !, should be:

UPDATE (TABLENAME) SET TABLENAME.Quantity = TABLENAME.Quantity + FORMS!FORMNAME!CONTROLNAME
WHERE TABLENAME.FIELDNAME = FORMS!FORMNAME!CONTROLFIELDNAME


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK