G
gmenon100 via AccessMonster.com
Hi,
I have a form (lets call it form 1)with a combobox linked to a table. On
this form I have a subform(read only) (lets call it Form2) which filters
summed totals from the same table. On the subform I have a sub nested form
(lets call it Form3) which gives a bread down of the totals (inshort the
individual record). Now when I select a criterial from the dropdown box on
form1, it pulls the record on the form2 and the nested subform3. All works
fine until here.
Based on circumstances, I need to update the Form3 on which I have allowed
edit. However, when I edit on this form, Form2 does not get updated unless
I change the criteria on Form 1 and come back to the same criteria I edited
previously.
can someone please help me, so that no sooner I update a field in Form 3, the
form 2 also updates immediately without having to browse out.
Appreciate any response. thanks in advance.
I have a form (lets call it form 1)with a combobox linked to a table. On
this form I have a subform(read only) (lets call it Form2) which filters
summed totals from the same table. On the subform I have a sub nested form
(lets call it Form3) which gives a bread down of the totals (inshort the
individual record). Now when I select a criterial from the dropdown box on
form1, it pulls the record on the form2 and the nested subform3. All works
fine until here.
Based on circumstances, I need to update the Form3 on which I have allowed
edit. However, when I edit on this form, Form2 does not get updated unless
I change the criteria on Form 1 and come back to the same criteria I edited
previously.
can someone please help me, so that no sooner I update a field in Form 3, the
form 2 also updates immediately without having to browse out.
Appreciate any response. thanks in advance.