Automatically check a box on a form using code

  • Thread starter Thread starter mattieflo
  • Start date Start date
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!
 
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
 
Back
Top