IF NOT EMPTY( This.DisplayValue ) AND This.ListIndex = 0 *** This next statement assumes that the RowSourceType of the combo *** is 2-Alias. If not, just change rthe code the suit your *** RowSourceType INSERT INTO ( This.RouwSource ) VALUES ( This.DisplayValue ) This.Requery() ENDIFYou do not need to do a replace in the bound table as long as you set the ControlSource of the combo. It will update the bound table - no code required.