How to code for reduction in a DB (Resolved)

hey.
I am crap at VB, and I need to do a code for school. and I have hit a bump.
I am making a program that records stock to a database. and I also have an Invoice form. The problem is that, when I use the invoice it uses the information from the stock database, and puts the calculated information in text boxes. eg Cost and Tax Cost.
But I need to make the invoice alter the database which changes the level's of stock, when a sale is entered into the data base.

What code do I need? keep in mind im a extremely crap at VB

thanks to anyhelp in advanced.

VB Program here (zip file)

File size is 47kb

That's VB6... Not VB.NET. You are in the wrong Forum. Go back to the VB Classic Forum

What code do you have so far? Show us that and we could guide you from there.

It has been resolved, thanks for your help anyway,
mendhak.
Tec-nico helped me in the visual-basic classic...
I didnt know which section to post this problem so I posted in both.

ady