><>SELECT partname From part INTO cursor mycursor ORDER by 1 >in combo.init event and use this cursor as rowsource, or just reopen the table >USE part In 0 AGAIN ALIAS mypart >and 'mypart' as rowsource. >Also, there are plenty of other opportunities.>> > >thanks a lot for your help in the combobox value sorting. but now i'm faced with a new problem. even though there is no problem when i'm running my program but everytime after i quit my program (without any errors) the error message "cannot select across selected table" appears. perhaps u can help me figure otu what's wrong with my program. thanks a lot
This message usually indicates that you have cursor as combo.rowsource and it's something wrong with this cursor. You may try to issue This.Mycombo.Rowsource='' in Form.Destroy event and see, it may help. PS: it's not necessarily a combo, it might be a grid too.