I am trying to set up a locator system to track inventory. This is probably a simple question but I can’t figure it out.
I have a table to keep track of the transactions. What I want to do is have the user enter whether the item is coming or going, I have a lookup Field and the user can pick Shipping or Receiving. What I want to do is have the next field look at whether it was Shipping or Receiving and when the quantity is entered, make it a negative number (Shipping) or keep it positive (Receiving). Then it is simple to total the quantity in each location. I know how to set up the If statement in the form, attached to AfterUpdate, how do I make the number a negative? Thanks.
