>when i use sql statment to setting up the combobox rowsource, when the SQL statment active and run a small window with the result from the SQL statment will prompt out, why?!

What is the SQL statement? Try adding "INTO CURSOR TempCursor" at the end of it.