Can a combo box requery itself?

[chrizzis]

Hi,
I have a main form that has a subform with a combo box. If the user wants to enter new data that is not in the combo box list, he must push a button on the main form that will open up another form where he can enter the data and close out the form. I did this using the wizard for the button. Now I have an issue where the combo box will not show the updated record after the new data is entered and the "popup" form is closed. I used the Google search and found threads on doing a requery on the closing of the popup form, but it didn't work for me. I think it might be the way I set up the opening of the popup form. I was wondering if I could make the combo box requery itself when you click on it. I tried:
DoCmd.Requery "cmboCerts"
for On Click
but it still doesn't update the list.
Thanks,
-C

 

[dcb]

From the form the combo is on

Me.cmboCerts.requery

From the On Close Event of the PopUp Form

Forms!yourformname.cmboCerts.requery
or
Form_yourformname.cmboCerts.requery

 

[chrizzis]

Worked great! Thanks!

 

[dcb]

Cool - Pleasure