>I try to use,
>in sql order by thisform.order.vlaue
>but now working, how can be
>
>thanks
What is the value of thisform.order.vlaue?
Try this
m.lcFieldName = TRANSFORM(thisform.order.value)
SELECT ... ORDER BY &lcFieldName ....
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.