Aug 15, 2001 #1 rkottke Technical User Joined Aug 13, 2001 Messages 6 Location US 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?
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?
Aug 15, 2001 #2 JoeMiller IS-IT--Management Joined Apr 27, 2001 Messages 1,634 Location US In the UpdateTo field place the code like this: [FieldName]-[Forms]![MyFormName]![MyControlName] HTH Joe Miller joe.miller@flotech.net Upvote 0 Downvote
In the UpdateTo field place the code like this: [FieldName]-[Forms]![MyFormName]![MyControlName] HTH Joe Miller joe.miller@flotech.net
Aug 17, 2001 #3 Dzidze Programmer Joined Aug 10, 2001 Messages 49 Location CA 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... Upvote 0 Downvote
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...