I did miss out the Exit Sub but I solved the problem quite a few days ago. Thanks for your help anyway.

I have a another query regarding how to add the records of a field to a listbox. I've already posted a thread and was hoping you would have a look at it. (In database section)

thanks!