Form with Subform changes record when open/close other form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
While openning or closing Form C do you perform a requery on form A or B or
both?
Does the value in the combo change while openning form C?
 
Ofer, thanks for the reply. You hit it. I had a requery on the Activate
property of the main form A (don't know how it got there!). Once removed,
all was back to normal. Thanks again.

Denny G.
 
Back
Top