>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, I just sent you the working sample by e-mail.

Nick