Fantastic! Works as expected. Thanks again for everyone's help.

Thanks for all the input. CREECE , I want to add this to a standard sales order and not a custom form. Any ideas?

Thanks everyone for the input. I will update if I can find a solution.