Hello all-
I have a formset with 2 forms.
First form - User selects customer's order from a list box populated from a view showing company name, order #, and order status.
Second form - User modifies data from order. When this happens if the
status of selected order was a 1, it changes to a 2.
Problem - After modifying data for the selected order on the second form, updating the tables, doing a requery of the list box on the first form (ThisFormset.Form1.Mypageframe1.Page1.customerlistbox.requery), and a
refreshing the first form (ThisFormset.Form1.Mypageframe1.Page1.refresh),
when the second form is closed the first form still shows the order
status as a 1. If I exit and run the form again it shows a 2. (as it
should)
Question - How can I properly update the view so that it shows the
updated order status correctly when the focus returns to the first form?
TIA,