Ahhh! One last thing i have now noticed! If the user presses the button when nothing is entered in the boxes then we get debug error "Invalid Procedure Call or Arguement".

How would i put in a Msg Box to prevent this sub being carried out if there were no values present in the two required boxes???

Many Thanks