The detail form must be closing the cursor. Ensure that its DE doesn't do this. To find out for sure put a SET STEP ON when you return to the original form to see if the cursor is indeed gone or something else is screwy.
I would consider using private datasessions in each form. Pass which table and which record you want to the details form . Then they won't affect each other.
>i have a form with a grid on it. the grid has multiple columns and some of the columns have a combobox control as the current control.
>
>all of the combobox controls have a rowsource type of 3 and the rowsource for each one is a seperate sql a select statement. the grid displays fine and the combocontrols work fine.
>
>my form also has a detail button on it which dynamically builds a detail form to allow editing of a single row from the grid. i do this by scanning thru the grid columns and using all of the property settings from the grid columns current control. i dynamically instantiate controls for the detail form and set the properties to place them as well as define the behavior based on what i read from the grid column.
>
>the problem that i am having is that when i close the detail form to go back to the form with the grid, i get the message can not access selected table. for some reason the cursor that drove one of the combobox controls gets closed.
>
>i am a bit stumped because there are multiple columns in the grid using this technique and only one column has the problem with the cursor closing. in fact, i have used this technique throughout my entire app and i only have a problem with one colum on a single grid.
>
>i can't figure out why or what to do...?
>
>thanks in advance for any insight.
>pbd
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only