forcing update of subform without close & open form

[gykiang]

Hi

My subform is linked to the mainform.



The problem is when I update the linked field (combo) of the main form, the value of related fields of the subform remains unchanged.

However, changes of these related field values will take place only when I close the form & re-open it.

Is there anyway I can force a change of the related fields of subform upon update of the key field of main form instead of update field, close form & open form ?

Thanks for your guidance.

Regards
Kiang

[pbaldy]

Have you tried to requery the subform?

[gykiang]

Thanks for the suggestions.

I have googled & found the solution by adding .requery to the control field of current form property, all related fields of Subform changed according to my
update in the main form.

Regards
Kiang

[pbaldy]

No problem.