Automatically check a box on a form using code

[mattieflo]

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!

 

[Alex Dybenko]

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

 

[Tom van Stiphout]

On Thu, 21 Aug 2008 11:42:02 -0700, mattieflo

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