Dear All,
Good Day,
I create a table and form with Stock inventory and transaction, what i need i want to deduct qty from stock inventory when i make transaction i request please help me to resolve this.
Thank You.
Dear All,
Good Day,
I create a table and form with Stock inventory and transaction, what i need i want to deduct qty from stock inventory when i make transaction i request please help me to resolve this.
Thank You.
If you haven't already I would strongly advise you to read http://allenbrowne.com/AppInventory.html
This will save you from going down some rabbit holes that are very difficult to get out of.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
I agree totally with Minty. Also, see the Similar Threads a the bottom of this page for ideas.