>I tried that at some point in time, but I will try it again. There could have been more than just that wrong at that time.
>
>When I stick the value into the combobox using DisplayValue does it get saved that way? Or do I have to do a REPLACE for it to be saved?
>
>Every time I think I have comboboxes under control, I don't.
>
>Thanks for helping me. I am working until 1:00am tonight. Burnin' the midnight oil! But at least I am getting paid for these fun and games.

Yes, if DisplayValue is not part of RowSource, and you want to save it there, then you must do it programmatically, e.g.

***Combo.LostFocus
IF NOT (This.Value==This.DisplayValue)   && this indicates the case
 INSERT INTO mytable (...) VALUES(...)   && here you save in 'rowsource'
 This.Requery                            && here you 'update' list portion
ENDIF