>>Check
Cannot access selected table error FAQ #18812
>>
>Hi Sergey:
>
>Thank you for your kind response.
>
>1. I have only one combobox whose InterActiveChange executes an SQL statement. However, I do set the RecordSource = ""
>
What is the exact syntax for SQL in the combobox? Do you select into cursor? Can you check, if this cursor is used when you close your form?
(E.g. you can put in Destroy:
messagebox("My cursor is "+ iif(used("MyCursor"),"","not ") + "used"))
If it's closed, you found your problem...
>
thisform.pageframe1.page4.grid1.RecordSource = ""
>thisform.pageframe1.page5.ravibasegrid1.RecordSource = ""
>thisform.pageframe1.page6.ravibasegrid1.RecordSource = ""
>
>2. The cursor name has been the same since the recodrsource is only refreshed when data is Saved, Deleted or Updated. Therefore, the cursor name is the same when either of the 3 actions of taken.
>
>3. I have not executed a "Close Tables" in the Interactive change of the combo or in any of the 3 action command buttons.
>
>Interesting, I did a debug and stepped thru the code. Everything works well, except that the form does not get released. Further, the form hangs even without me using either the Save, Delete or Edit actions. Now, even the error message does not show up. CmdREturn button is part of my baseform, whose click event is "thisform.release()".
>
>Appreciate your guidance.
If it's not broken, fix it until it is.
My Blog