>I have one table in a form's Data Environment. The table in Data Environment shows me the fields and indexes available from that table including an index called 'itemno', but when I need to order or re-order the table programmatally using:
>
>thisform.DataEnvironment.Cursor1.Order = itemno
>
>it gives me an error complaining that it can't find the index name.
>
>Am I using the wrong command or syntax, or maybe there's just another wat to do it.
>
>I would appreciate any ideas,
>
>Thanks,
>
>Steve

Try thisform.DataEnvironment.Cursor1.Order ="itemno"