Substracting value of record in table based on data in form

[darekg11]

Hi, I have a problem.
I have a continous form with fields:
ID_product, Name, Ammount, Price



Now when I click my button: "Save" I would like to make ammount of ID_product to be calculated and removed from table: "Products".

For example:
I have a table Products with 3 records:
1 Bla bla 5 2.20 Euro
2 SOmething 3 4.44 Euro
3 Umbrella 4 1.22 EUro

Now I have entered on form:
1(ID) name is aumatically added to form 1 price is automatically added

So it should remove 1 product Bla bla from table Products.

So i tried to declare global dynamic array of size of products(3); it worked.
Then I wanted to enter ammount of each entered product into each element of array.
But everytime when I have tried to reffere to this global array frmo functions access throw out Null error.

Please advise me how to use global variables or how could I make it work easier way?

[June7]

Need to provide code or database for analysis. Follow instructions at bottom of my post.

I don't see how using array helps modify records. Why would you delete product records?

Have you looked at the Northwind sales template database? http://office.microsoft.com/en-us/te...001228997.aspx