Change value is form based on value in subform

[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

 

[Boyd Trimmell aka HiTechCoach via AccessMonster.co]

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

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