Setting a main form control based on subform details

  • Thread starter Thread starter Dennis Snelgrove
  • Start date Start date
D

Dennis Snelgrove

I can't believe I'm posting this, but I can't seem to get this to
work...

I'm setting up a simple form with one subform. I need to enable or
disable a checkbox on the main form based on both the count of the
entries in the subform, and the sum of a field on the subform records.
I've got a function already built which will do this, but I need to
apply this whenever the main form changes to a new record. The problem
is that if I use the main form's "On Current" event procedure to test
and set the checkbox, the subform hasn't populated itself at this
point. As a result, I can't do any tests on the contents. I have no
idea what event I should use.

Any suggestions? I'd really appreciate some insights...
 
Back
Top