Thank you very much for your help RickyO this worked perfectly.
I would like to know if there is a way to prevent the program from allowing a sale if there is 0 stock to prevent negative stock.