G
gmenon100 via AccessMonster.com
I have a main form with 1 combobox (unbound). On the same form, I have a
subform (ordertotals) which has a subform (orderdetails),
The mainform and subform1 have master and child fields connected and the
subform1 and subform 2 are also connected.
Now when a value is selected from the combobox, it filters order totals in
subform 1 and order details in subform2.
Subform 1 is read only, whereas subform 2 can be edited.
My problem: When I edit any information on Subform 2, the value in the
subform 1 does not change or refresh, unless I go to the combobox and change
the selection and comeback to the original value.
Can someone please help me formulate this so that whenever a change is made
in the subform2, subform1 updates automatically.
All help is sincerely appreciated.
Thanks in advance.
gmenon
subform (ordertotals) which has a subform (orderdetails),
The mainform and subform1 have master and child fields connected and the
subform1 and subform 2 are also connected.
Now when a value is selected from the combobox, it filters order totals in
subform 1 and order details in subform2.
Subform 1 is read only, whereas subform 2 can be edited.
My problem: When I edit any information on Subform 2, the value in the
subform 1 does not change or refresh, unless I go to the combobox and change
the selection and comeback to the original value.
Can someone please help me formulate this so that whenever a change is made
in the subform2, subform1 updates automatically.
All help is sincerely appreciated.
Thanks in advance.
gmenon