Change value is form based on value in subform

  • Thread starter Thread starter Ivor Williams
  • Start date Start date
I

Ivor Williams

I have a form with a number of subforms. The subforms are continuous forms.
On the subforms are a number of checkboxes and textboxes. When a checkbox is
checked, the BackColor in the text box in the same record is changed using
conditional formatting. I would like to have a textbox on the main form
change color whenever all the records on a subform are complete. How can I
accomplish this?

Ivor
 
In the sub form's after update event, you could use VBA code to check to see
if all the all the records in the sub form have been complete or not and then
update the Me.Parent form's control accordingly.

Hope this helps ...
Boyd

Ivor said:
I have a form with a number of subforms. The subforms are continuous forms.
On the subforms are a number of checkboxes and textboxes. When a checkbox is
checked, the BackColor in the text box in the same record is changed using
conditional formatting. I would like to have a textbox on the main form
change color whenever all the records on a subform are complete. How can I
accomplish this?

Ivor

--
Boyd Trimmell
aka HiTechCoach
http://www.hitechcoach.com
http://www.officeprogramming.com

Message posted via AccessMonster.com
 
Back
Top