A colleague worked out that the subreport has to be in a list box for this to work. I did that now its working correctly.