Group: microsoft.public.access
From: "(PeteCresswell)"
Date: Thursday, October 18, 2007 2:47 PM
Subject: Re: Retrieving Value From Subform Only Works In Break Mode

Per Pieter Wijnen:
>one more thing
>why don't you just use the subforms control as the controlsource of the main
>form?
>ie = Form!subTrades!Form!txtParTotal

Doesn't seem to work either.

In the end, I wimped out and just wrote a Private function within
the form to retrieve the total by banging some SQL up against the
local work table where the detail lines live. Doesn't seem to
take any appreciable amount of clock time so I guess I'll just
leave it at that.

--
PeteCresswell