Thanks Alex... I'm out of the office tomoz so wont be able to give it a go until thurs :(
Do i need to change anything to the names of my files (query etc..), and where will this code be run, I know its on the on click of the button ...I'm guessing it's the button on the form with the combobox...