Simple Problem Driving me maD! Plz Help :)

[Rixx]

Hi there,

I am new to this forum and am currently a Degree Undergraduate. I need help on what I think is a simple problem!

I am creating a stock control system. My problem to put it bluntly is Updating the Stock Table. In other words:

1.Quanity of items being bought is entered in the Order Form (e.g.2 Pens)
2.Product Table shows that there are 10 items in stock.

= I want it to show as "8 PENS" after the form is closed!! Please Help!!

ALTERNATIVELY I have created a query that performs the calculation, my simple question is...


I want to take the value from the query and put it in the 'current items in stock place'! How do I do this?

e.g I have got the query to work out that its 8 pens left. But I dont know how to replace this value in the place of the current value in the Products.ItemsinStock table.

Please Help

 

[Pat Hartman]

You already have this post in another forum. Please don't post the same question multiple times.