After Update Problem

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!
 
G

Guest

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

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

Steve
 
G

Guest

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top