>>it is possible for a combobox to get it's row value from a field in a table? if yes, how can i do that? anyone can give me a sample coding? i will be very grateful to anyone who can help me on this. thanks
>
>You may set Combo.Rowsourcetype=6 and Combo.Rowsource='Mytable.Myfield1,Myfield2....'
>
>i've successfully displayed the value from the table into my combobox using the commands u gave me.
>
>i have combo.rowsource as 'part.partname'
>
>now the question is, can i sort the partname is ascending order?
>
>thanks to you in advance
You may sort the rowsource itself, i.e. SET ORDER TO TAG partname IN part. Here, you might want to separate the rowsource from real table, because the table may change its order during the application flow. Therefore, it might be useful, either
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.
Edward Pikman
Independent Consultant