combobox doesn't display new record after adding new item

[gdev]

Hi,

I have unbound combo box that uses the findfirst method in the afterupdate event to display records on main form.
After adding a new item to the combo box using the notinlist event, the afterdate event findfirst method does not display the new record until I close and reopen the form. The new name will appear in the name text field.

I have used cbocallerid.requery and me.refresh. Nothing works.

Please help

Thanks

Gwen

 

[PHV]

And this ?
cbocallerid.RowSource = cbocallerid.RowSource

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[gdev]

Thanks for responding

Unfortunately,it didn't work, cbocallerid.RowSource = cbocallerid.RowSource.


Gwen

 

[cghoga]

Try...

Me.cbocallerid.RowSource = Me.cbocallerid.RowSource

or in the properties of the cbocallerid copy the rowsource and then paste it in your code where you reset the rowsource.

me.cbocallerid.RowSource = "Select...."

hope this helps.