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