I am having trouble tracking down the source of an error that happens frequently but not consistently. The error is 1152 - 'Cannot access the selected table'. When I can make this error occur, I do it with the following process:
I have a form that has several pages. There are several dropdown lists throughout the form on different pages. The row source for the dropdown lists is a cursor. I add a new record and save it. I then add another new record and try clicking on one of the pages that has a dropdown list. At this point I get a dialog box with the error message 'Cannot access the selected table' and two options on the dialog box: OK and Help. (The application error handler I have implemented is not trapping this error.) When I click 'OK' the page I clicked on becomes activated but the dropdown list has disappeared.
The explanation in VFP help about error 1152 is not very useful to me. Has anyone run into a similar problem or have any ideas?
George Simon, MCP