Hi yes all the relationships were set up correctly, i managed to find a work around.
It worked if i put in a subform rather then a subreport, i know this is stupid really but yeah, it works now with the Subform, so ive just formatted my form to look like a report!!
Thanks for you feedback...