Coann

Try the code below after your SQL statement executes. Or put it in the init event of the box itself. Sounds like you want to show a value if the SQL statement returns any values and you would like it to be the first value.

THIS.listindex = IIF(THIS.listcount > 0,1,0)

HTH



>My combobox rowsource is a SQL statement , everytime i run the form, it didn't >show any value at the combobox, i need to select...how can i make the combobox >display the first value?