George / WayneRyan,
Thanks for asking after all this time, sorry i did not reply to you earlier as i have been spending most of my time at college doing additional courses like Crystal reports and a couple of beginners courses in Networking. The project i was working on back then was a Holiday Database from the point of the company has been replaced by a Excel sheet??? but i am still doing little bits to it as its still my task to finish what i started. Amazing the info and samples on here, i seem to think i have found something good and until 5 minutes later when i find something better to do the job, lol. The DLookup works fine and i have been using DSum and DCount on some of the forms i have where there are List boxes in them. So thanks again for the help of yourself.s and all others like, NigelShaw, BobLarson, and Wazz.
I will be posting the finished item so to help other as all you have helped me.
Steve