>Nick -
>
>I tried your code first because it was shorter, but still can't get it to work. At a basic level, for some reason my insert into my Cities table (I'm trying to add "Test") isn't working, which is probably why when I try to then save the record I get a trigger failure (anyway when I check the cities table nothing is there). Another issue though is the combobox "ControlSource". Only when I set it to "" does the phrase I type remain on the combobox after I lose focus. But it seems to me if I don't have a control source then, when I navigate through my records, the same city will display for all the records.
>
>sylvia
Sylvia,
(Nick correct me if not true) In Nick's method it's important what your rowsource is and if fields or SQL, when requeried would update the list from original source. If it's the table you're using and buffering is on then additem item would be dropped (true Nick ?) or SQL then also would be refreshed (updated) from source. BTW main difference between refresh and requery (saying in other words than help) one deals with controlsource(s) while the other deals with rowsource. If you're using a rowsource from a lookuptable then :
this.displayvalue = this.value
this.value = this.displayvalue
this.displayvalue = this.value
could be all you need (never was for me so wrote that class).
Cetin