Requery Does Not Work

[Lynn_AccessUser]

I have a MainForm with a subform. On the MainForm you can open a popup form to add a new record to the combo list for the subform. However, I can not get the combo box to requery. If I close out the main form and reopen it the combo box shows the new record that was added so I know the record is being added OK to the table.

Here is my code:

Private Sub Save_Record_Click()
On Error GoTo Err_Save_Record_Click


DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Forms![frm_Summary]![frm_sub_SummaryCoAdmin]![cmb_CoAdmin].Requery

Exit_Save_Record_Click:
Exit Sub

Err_Save_Record_Click:
MsgBox Err.Description
Resume Exit_Save_Record_Click

End Sub

 

[Lynn_AccessUser]

Never mind I copied the requery code to the event code on the button to close the form and now it works.