After Update Problem

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

Guest

I have a main form (frmSummary) and a subform (frmChildInfo) linked by a
ClientID field. When a parent is chosen from a combo box any children
associated with that parent should populate the subform. I'm currently using
the AfterUpdate event on the parent combo box, however, it isn't working
quite right. For example, when I first open frmSummary, if I choose Client
A, their children show up in the subform, however, if I then go to Client B,
the subform does not update. It still shows Client A's children. If I
initially choose Client A and THEN click in the subform, and THEN choose
Client B, client B's children will populate the subform. In other words, it
seems as though I have to click inside the subform before choosing the next
client in the combo box, or the subform will not update. Any ideas why?

Thanks!
 
Do you have your subform control's Master/Child links set?

What is the code in your AfterUpdate event for the combo?

Steve
 
Actually, I just realized my problem. I had the Master field set to
ClientInfoID when it should have been set to cboClientInfoID. Looks like one
of your suggestions was to check that very issue.

Thanks for your response!
 
Back
Top