snowbunny2
Technical User
Hi - Ive a database which contains 2 tables. tblstocktype and tblstationery stock.
they are linked by stock type.
I am creating a form which shows opening stock, stock taken out, stock added in and then current stock balance.
What I need to be able to achieve is when I add stock or take out stock, for the current stock balance to change (I know I can do this through an unbound box and enter a formula in), but I also need to show the new new current stock balance. formula at the moment is opening balance + stock added in - stock taken out, which works fine for the first adjustment, but any after that are not correct.
Can anyone help please. I'm fairly new to access and haven't a clue on VB or SQL
they are linked by stock type.
I am creating a form which shows opening stock, stock taken out, stock added in and then current stock balance.
What I need to be able to achieve is when I add stock or take out stock, for the current stock balance to change (I know I can do this through an unbound box and enter a formula in), but I also need to show the new new current stock balance. formula at the moment is opening balance + stock added in - stock taken out, which works fine for the first adjustment, but any after that are not correct.
Can anyone help please. I'm fairly new to access and haven't a clue on VB or SQL
