Append or Update Query Not Updating Table

[rkottke]

Hi,
How do I have a number that's currently in a table be reduced by a number that's entered in a form and be replaced by the new total?

 

[JoeMiller]

In the UpdateTo field place the code like this:

[FieldName]-[Forms]![MyFormName]![MyControlName]

HTH Joe Miller
joe.miller@flotech.net

 

[Dzidze]

Or you could put that result in avariable and then update your table using that variable.

Both ways will work for you, but I always tend to avoid calculations of values during an update of database.

Have fun...