Automatically check a box on a form using code

M

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!
 
T

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
 
Top