I have googled myself silly and can't resolve this. frmEntry has a subform named frmEntrySub with a combobox named boxGuideTypeId. When a new guide type needs to be added another form opens to add the record. Upon closing this form I want the combobox on the subform to have the new record. I have tried multiple ways and can't get the combobox to refresh. If I press F9 when I'm returned it works so the record is there.
Private Sub Form_Close()
If Me.Dirty Then DoCmd.RunCommand (acCmdSaveRecord) ' save the record
DBEngine.Idle dbRefreshCache 'supposed to force a write of the record
Forms!frmentry.Visible = True
[Forms]!frmentry!frmEntrySub.Form.Requery ' none of thes work or throw an error
Drives me crazy that there are multiple ways to refer to subform objects. I have tried change the name of the subform control so it is different from the name of the subform and nothing seems to work.