Mace

Do you mean the PERMISSIONS table being used by a grid/combobox?

Kev

>Hi Kevin,
>
>I've noticed this strange behaviour when there are grids or combo boxes on the form. It normally happens because the recordsource or rowsource table is being modified or manipulated. If it is this in your case, you can try to set the rowsource or recordsource to an empty string, perform your calcs and the restore it.
>
>Best of luck,
>
>Mace
>
>>Hi
>>
>>I've had this problem for a while now, but it happens very rarely, and is impossible to simply replicate the problem.
>>
>>I have a seek that runs in my form class, but sometimes it will come up with an error of "Table has no index order set", here is the portion of code that it fails on, it's the SEEK that fails:
>>

*Open PERMISSION table and locate Screen
>>goCCMS.Used("Permissions")  && This opens the table btw
>>
>>*Obtain Permission settings for this screen and user
>>IF SEEK(lcScreenId + STR(gu_Userlevel,1), "Permissions", "PERMISSION")
>>     blah, blah.....etc.etc.
>>ENDIF
>>

>>
>>If I click Retry, it continues fine, like I said, it very rarely happens.
>>
>>Any suggestions.
>>Thanks
>>Kev