For the benefit of others who have looked here, I am back to tell you I found the problem myself. I had a requery in the Activate property of the main form A. Why it was there is beyond me. Once removed, all was back to normal. Thanks to all. Bunky
--- In [email protected], "bunkyfoly" <[EMAIL PROTECTED]> wrote: > I have a main form (A) with one linked subform (B). Main form A has > an unbound combo box that selects/filters to a specified record group > in subform B. Works perfect! On the heading of the main form A, I > have a button that opens an unrelated form (C) to add data while form > & subform (A and B)remain open. When I click on the button, add the > new data, and then close form C, subform B immediately changes the > record. I do not want the record to change and I have never seen > this happen before. > > Will someone please tell me how to keep the subform B on the same > record when I open and close form C? Thank-You > > Bunky Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
