>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