Hello Power.

Thanks for your quick help. I tried to use your code. In fact, after your code, I still need to add one more line:
thisform.Combo2.value = TempComboValue
where TempComboValue is I used to store the Combo2.value before I do the INSERT statement.
If I don't add this line, the Combo2 was still gone to blank even after your .Refresh().

Well, I am glad that I was able to point you in the right direction. The main thing is that you have it working now <s>.