S
shanebgross
I have a database to track projects. I have one table with the project info
and second linked table with tasks for each project. I have a form to update
the project with a subform listing the tasks associated with the project. I
have a combo box on the main form for the status of the project and a check
box on each record in the subform to be checked when that task is completed.
After the check box is updated, I want to check all the task check boxes and
if all are now checked I want the combo box set to "completed." I have two
text boxes in the subform footer. One counts the records and multiplies by
-1, the other sums the value of the check boxes. I have a macro on the after
update of the check box that refreshes the records, checks if those text
boxes are equal, and if they are sets the combo box to completed. This all
works, the problem is that the calculated control text boxes seem to update
too slow and calculate after the macro is finished checking if they’re equal.
So if all are checked, and one is then unchecked the macro sees the boxes as
equal before they get updated, and sets the combo box to completed. How can
I make this work?
and second linked table with tasks for each project. I have a form to update
the project with a subform listing the tasks associated with the project. I
have a combo box on the main form for the status of the project and a check
box on each record in the subform to be checked when that task is completed.
After the check box is updated, I want to check all the task check boxes and
if all are now checked I want the combo box set to "completed." I have two
text boxes in the subform footer. One counts the records and multiplies by
-1, the other sums the value of the check boxes. I have a macro on the after
update of the check box that refreshes the records, checks if those text
boxes are equal, and if they are sets the combo box to completed. This all
works, the problem is that the calculated control text boxes seem to update
too slow and calculate after the macro is finished checking if they’re equal.
So if all are checked, and one is then unchecked the macro sees the boxes as
equal before they get updated, and sets the combo box to completed. How can
I make this work?