Subform calculated link

[el_chileno]

I am trying to create a macro to step through all the records in a form to compare a calculated value from a subform in one control source with another value on the main form. The problem is that the macro compares the two values before the calculated value from the subform is updated. Is there any way to force the macro to wait until the value is updated or force the calculation to occur? I have tried requery, refresh, and recalc but none of these seem to work.

 

[Dugantrain]

Sure. It seems that so long as your Calculation code executes and then you Requery and then your comparison code executes everything should run as needed. I know that this is redundant, but it should work; use the debugger tool to step into your code and make sure the order of your execution is OK.

 

[el_chileno]

There is no calculation code. The calculation is a control source linked to the subform. There is a sum field in the subform that returns the total to the main form.