>i won't know what is the value, cos that is a value that input from user, i use SQL, coz i don't want to have duplicate value.
I think you will have to give more detail on what you are trying to do. I generally use cursors or "None" for the RowSource so i'm not quite sure what you are trying to do. However, I would suggest using your SQL to load a cursor, then bind the combo to the cursor. Then you can determine which item in the combo you want displayed initially.
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.