Hello,

I have a mainform Emails that contains a subform, POs. The PO subform is a
continous form which has a field called Date Completed. An email can contain
many POs. On the mainform, there is a checkbox that is labeled 'Completed'.
What I need is when all the completed dates on the subform is populated, the
main form checkbox gets checked....I'm trying to do this from the on current
event from the subform, but does anyone have a suggestion on how I should
program this? Thanks!

Hi,
I think you need to use AfterUpdate event of subform, so only when record
was edited - then you recalcualte the value of checkbox

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

"mattieflo" <(E-Mail Removed)> wrote in message
news:AA8D0B9E-FCB7-4A8E-9D2A-(E-Mail Removed)...
> Hello,
>
> I have a mainform Emails that contains a subform, POs. The PO subform is a
> continous form which has a field called Date Completed. An email can
> contain
> many POs. On the mainform, there is a checkbox that is labeled
> 'Completed'.
> What I need is when all the completed dates on the subform is populated,
> the
> main form checkbox gets checked....I'm trying to do this from the on
> current
> event from the subform, but does anyone have a suggestion on how I should
> program this? Thanks!

On Thu, 21 Aug 2008 11:42:02 -0700, mattieflo
<(E-Mail Removed)> wrote:

You should not have a field in the Emails table to store Completed,
because it is a calculated value. I.e. it can be calculated by
inspecting the child records.

-Tom.
Microsoft Access MVP



>Hello,
>
>I have a mainform Emails that contains a subform, POs. The PO subform is a
>continous form which has a field called Date Completed. An email can contain
>many POs. On the mainform, there is a checkbox that is labeled 'Completed'.
>What I need is when all the completed dates on the subform is populated, the
>main form checkbox gets checked....I'm trying to do this from the on current
>event from the subform, but does anyone have a suggestion on how I should
>program this? Thanks!