>>I have a form containing a listbox displaying one field from a free table. The table is listed in the Data Environment of the form(along with a few others required for the report). The table in Data Environment displays the correct field under index, but after trying to index several different places, I can't seem to index the listbox. I tried the init code of the table in Data Environment (cursor), and I tried indexing in the command button which calls the aforementioned form. If I try to:
>>
>>use mytable
>>index on myfield to something
>>
>>I get an error 'file is in use' (by Data Environment I assume).
>>
>>Any help would be greatly appreciated.
>>
>>Thanks
>
>Steve, why are you indexing "on the fly"? Index your table, then in the data environment set the index tag to that index.
>
>About your error message: The Data Environment USEs the table, so it can't be opened exclusively as is necessary to re-index. Your USEing again gives the error.
>
>Leave a message about what you're trying to accomplish. There's probably an easier way.
>
>HTH
>Barbara

Thanks for the reply. All I really want to do is to index the records in the listbox. You mentioned that I should set the index tag in Data Environment, how/where do I do that. I've tried several different ways from within Data Environment, but I'm just not seeing the results.

Thanks again

Steve