Stock Levels

[Foster]

Hi All,
I am trying to do this but, to be honest, do not really know where to start!! Could anyone point me in the right direction? I know the basics of access but not VB etc.

I have a quote form from which I select a material (via a combo box) and then type in the quantity required. This material info is taken from a materials table. When the quote becomes a sales order, there is a check box I tick to say it is now a sales order. On the materials tables there is a column for stock level.

What I am trying to do is, for example, say I pick "XXXXX" as a material and put in 5 for quantity on the quote form. When I tick the box to say it is now a sales order, the stock level in the materials table is automatically deducted by 5 for that material? Does this make sense?

Hope someone can point me in the right direction.

Thanks for taking a look.

F.

 

[GordonR]

I think what I would do here is to have an update query go and do the job of adjusting the stock level on the corresponding product.
Hope this helps