Hi - I have a two subforms on an unbound main form. I use a textbox on the mainform to synchronize the two. The first subform is a continuous form to pick which order you want to edit; the second subform is where you edit the data for the order.
When the user changes the order total (quantity or unit cost) in the second subform, I want it to update the first subform. Easy enough: In the AfterUpdate, I save the record and requery the first subform. The problem is that when the first subform requeries, it resets the pointer to the first record in the sort, making the second subform also change to that record. I don't want that. I want the first subform to requery, then return to the record it was on before the requery.
I've tried several different ways, but here's the latest iteration. It is in the AfterUpdate property of a textbox on the second subform. Be gentle....I am a novice trying to use my google-fu to solve problems...
Thanks,Code:Dim rst As DAO.Recordset Dim varBookmark As Variant Set rst = Me.Parent.subOrderSearch.Form.RecordsetClone varBookmark = rst.Bookmark Me.Parent.subOrderSearch.Form.Requery rst.Bookmark = varBookmark
Phil