subform not refreshing

[MarcusMaximus]

i have 3 subforms that give a summary of costs for a certain job. when the main form is refreshed 2 of the 3 subforms refresh but the third doesn't.

the 3 subforms are set to display 0 if there is no value to display. so i don't get #error displayed, purely for user piece of mind. The user enters the data into the main form and it is refreshed. 2 forms display all 0.00 as i want but the 3rd displays nothing till you actually go into the section. Any suggestions or am i after confusing everybody.

 

[ajetrumpet]

are the two subs that are updating linked to the main? is the 3rd one not?

also, you can always use this code to refresh a subform from the main form:

me.SubformControlName.Form.requery

 

[MarcusMaximus]

Turns out that the problem was that the sub forms that were refreshing had a one-many join on the query and the one that wasn't refreshing had a one to one join.

I have since changed changed and its refreshing but now i have "#error" on the sub form instead of 0.00 even though i have a iif statement to display 0.00 if the the value is null

 

[MarcusMaximus]

Solved. Problem was with the calculation on the query. For some reason #error was displaying in the query when the was no data to report. took a few brackets out of the calculations and it worked fine using the same formula