Refresh combo box list

R

R Marko

I've created a form where users must select a name in a combo box. If the
name is not in the combo box, they click on a button to open the form that
populates the combo box and add the name.

My question, after entering the new name and closing the form, the name
should appear in the combo box. Sometimes it does, other times it doesn't.
I've added the code

Forms!AddHotelStaff.Refresh

to the After Update field and then the On Close field but still no
consistency.

Any thoughts?

R Marko
 
K

Ken Snell \(MVP\)

Requery the combo box itself after you close the "new" form that allows
entry of the new data:

Me.NameOfComboBox.Requery
 
Top