>local lSource >lSource = "SELECT * FROM city WHERE !DELETED() ORDER BY 1 INTO Cursor " + This.Name >This.RowSource = lSource >This.Refresh >>This works fine.
>local lcNewCity >lcNewCity = proper(EditTextBox("", "Add new city")) >Insert into city (cityname) value (lcNewCity) >This.requery >This.refresh >This.value = lcNewCity >This.Displayvalue = lcNewCity >>When I run the form the combo displays all the current records, however if I rightclick and add a city it doesn't show up? I browsed the actual cursor and it's not there. It does exist in the base table, and will show up in the combo the next time I run the form.