Hi Minty,
Thanks for getting back to me, I'm a little new to this and been learning as i go. I've generally been using visual basic editor to change the code but will take a look and see if i can do this then post it back.
it would link the pdf to the database, pretty much it tracks it in...