>>>>>>Sometimes in my program, I'll get the message, when I switch from one page
>>>>>>to another in a pageframe, "Cannot Access the selected table".
>>>>>>
>>>>>>I can't find anything wrong in the data-environment.
>>>>>>
>>>>>>Can anyone help me,
>>>>>>
>>>>>>
>>>>>>Pascal De Borger
>>>>>
>>>>>Actually, it indicates some internal bug. Try to debug the place where the message going. One possible reason that you used SELECT(1) in some place, but it might absolutely another reason too.
>>>>
>>>>
>>>>If the table was closed too soon, this message will come up.
>>>
>>>Yes, but it's applied to all possible tables including internal cursors. I made a reply, because few months ago I hunted this error in one project and result was really surprizing.
>>
>>
>>I've had to hunt this one down too. It turned out to be very obscure, but ca table/cursor/view gets closed.
>
>And there might be some VFP unwanted behavior too. My preferred scenario (Hmm...) for this to happen is as follows: one form with a 3 pages pageframe, à la Codebook (Search criteria, data input and list). On the data input page place another pageframe with some pages. The first holds the parent information, and say the second child information in a grid. One on the grid elements is a combobox based on a view. Click back and forth enough between the combo and the pages and you should see this darn error.
>
>José

I can see this happening. There is lots going on in your case. You might want to try a different search technique, that I feel is more intuitive for the user and easier for the developer. It uses QBF Builder, available from www.classycomponents.com.