S
Stephane Pelletier
Hi,
I have a form with a sub form which also have a sub form (In other word 3
level). Each fields has it's source from underlaying queries. Now if I modify
the contents of those queries I'm unable to update a Subforms.
I would like that: Every time at least one query is change, the changes
should also be reflect on the forms. I've tried something like
Forms!frmClient.form.refresh not sure if it's work because frmClient is the
mother form but is i try something like
Forms!frmClient!frmReport.form.refresh where frmReport is the subform (second
level) well it does not work. I've tried with the .recordsource = "qryReport"
and it still doesnt work My forms wont display the new data. And I'm sure
that the change in the queries are accurate. My problems it's that the forms
(subform and subsubform) dont reflect the changes.
How can I do so?
(Whitout closing the form and re-open it ... in which case the display
reflect the changes, in other words all field are re-initialize to the new
values.)
Thanks for your helps
Stephane Pelletier
I have a form with a sub form which also have a sub form (In other word 3
level). Each fields has it's source from underlaying queries. Now if I modify
the contents of those queries I'm unable to update a Subforms.
I would like that: Every time at least one query is change, the changes
should also be reflect on the forms. I've tried something like
Forms!frmClient.form.refresh not sure if it's work because frmClient is the
mother form but is i try something like
Forms!frmClient!frmReport.form.refresh where frmReport is the subform (second
level) well it does not work. I've tried with the .recordsource = "qryReport"
and it still doesnt work My forms wont display the new data. And I'm sure
that the change in the queries are accurate. My problems it's that the forms
(subform and subsubform) dont reflect the changes.
How can I do so?
(Whitout closing the form and re-open it ... in which case the display
reflect the changes, in other words all field are re-initialize to the new
values.)
Thanks for your helps
Stephane Pelletier