Resort Entries in Combo Box

[Digsys]

I use a pop-up form to add an entry to the table that is being used as rowsource for a combo box. The problem is that when I close the popup form, I need to re-sort the entries so that the new one is included. Can anyone tell me how to do this

 

[krsherm]

In the On_Close event of your pop-up form, requery the combo box on the calling form. (you can also set the value of the combo box to the new value... let me know if you need help with that)...

Assumptions:
Calling Form (that called pop-up form): frmOriginal
Combo Box (On frmOriginal): cboCategory


Private Sub Form_Close()
Forms!frmOriginal!cboCategory.Requery
End Sub

Hope this helps....

Kevin

 

[Digsys]

Thanks very very much Krsherm. It worked perfectly