Subform Not Updating

Question

Hi there, 

I have a main navigation form with 2 subforms that I am trying to link. I have set the link master [CompanyID] and link child fields [CompanyID], but when I search a company in the 1st subform, the names in the 2nd subform do not change. Is there something extra I need to do since this in a navigation form?

I'm using the BrowseTo action to search the 1st subform, do I also need to add a BrowseTo action to requery the 2nd subform? If so, on which event do I add it to? After Update, and On Filter are not working.

BrowseTo

Form

frmNewCoAttention_DS     (2nd Subform record source)

frmNav_Main.navigationsubform>frmCompanyInformation_Nav.DS_Attention    

(frmNav_Main.navigationsubform>form which both subforms are sitting in.2nd subform name)

"[CompanyID]=" & [CompanyID]

Thanks for any and all help!

Answer 1

I've set the master and child fields.

If I set them for both subforms, all records except the first disappear and I cant get to the others.

If I set them for only the 2nd subform, all the records re-appear in the 1st subform, but it still wont update as I pick different records.

Answer 2

You have to set links for each master/child pair.