Carol,
You'll have to save all the data before updating your combos with SELECT.... statements. SELECT statements don't see buffered data.

After your REPLACE lines, just add the appropriate TableUpdate() commands.

HTH
Barbara