Update Combobox

[Ian]

I have a combobox based on a query (a group of active names). Occasionally
the user will not see the name they need in the combobox and have to add it
using another form then choose the name from the combobox.

Is there a way to update the values in the combobox without opening and
closing the main form? I've tried adding a requery and refresh when
OnGotFocus with no luck.

Thx.

 

[Ken Snell \(MVP\)]

Requery the combobox itself:

Me.NameOfComboBox.Requery


If you need more info, post the code that you're using for adding the new
item to the combobox.

 

[Ian]

thx Ken.

Requery the combobox itself:

Me.NameOfComboBox.Requery


If you need more info, post the code that you're using for adding the new
item to the combobox.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/