Hi Scott,

Have you tried to refresh Form1 when it gets activated?

>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,