[AccessD] Keeping a subreport on one page

Have I forgotten some very basic thing - I just want a subreport to stay together and I can't seem to achieve it simply. (the subreport is small and in itself could never be > 15 lines).

I have written a function which will tell me whether I want the subreport to go to a new page or not and based on that I want the subreport to stay or force a new page.

eg.

If CalcNewPageNeeded() = true then
    'do something here to force subreport to new page
Endif

I have also tried the 'on format' event of the subreport's header section, eg.

if CalcNewPageNeeded() = true 
     Me.Section(1).ForceNewPage = 1
Endif

but with no luck. 

What am I missing? TIA


Kath
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030724/4fb9832c/attachment.html>