Combo not working or updating not sure

[DaveMac]

I have an issue with a combo box.

The box is on a subform that is linked to the main form via a field called formula on the subform and Child on the main form. I added a combo that looks at a tbl that has a field called Child. I then added [Forms]![Frm_Pack_Lineup]![Child] in the query of the combo. The issue is when I first open the form it works. But as I navigate around to other Child parts the combo still shows the records of the first formula.

 

[dhookom]

As the main form changes records, the combo box on the subform needs to be requeried.

Duane
Hook'D on Access
MS Access MVP

 

[DaveMac]

thanks for the help. is there a better way to do this or should I just add a requery on the got focus?

 

[DaveMac]

got it. Made a macro that is a requery of the combo and put it in the got focus of the combo