How to update Qty in Stock from an Invoice when selected.

[tim_tims33]

Hi,

I'm trying to refine my Invoice system, although i'd love to update my Stock table with the 'Invoiced amount'.

I select the StockID (or in this case 'UniformID') using a lookup. My thoughts are how best to update the stock quantity after this invoice is issued.

Here's one way i've been thinking... Could i use the AfterUpdate event of the UniformID to run an update query? But would that be wise?

Here's the screen dump of what i'm developing...

Any advice/guidance would be appreciated

thanks

t