>I have a form on which there are 2 separate grids. Prior to loading the form, I run a query to pull in a distinct field (from each table) to populate a third table. This third table is used to set up the relationships to the first 2 tables. The reason for this is sometimes there is information found in one table and not the other.
>
>At any rate, the grids load fine originally. However, on the form there is an option to remove the items from these tables (grids) and move them to other files. The user selects a button and a confirmation form is displayed. When the confirmation form is closed and returns to the original form (with the grids), the grids appear empty.
>
>During the process of moving the items out of 'grid' to the other tables, the relationship is 'broken'. Therefore, I manually re-establish the relationships prior to the original form activating but the grids do not refresh. Rather I see two white boxes displayed where the grids should be.
>
>Any thoughts? Thanks in advance.
>
>-Missy
Missy,
Honestly I didn't understand why getting data out of grids would break the relationship. Have you tried (for each grid) :
local lcRecSource
lcRecSource = thisform.myGrid.recordsource
thisform.myGrid.recordsource = ''
* Go to other form
* On return do whatever
thisform.myGrid.recordsource = lcRecSource
PS: I hope datasessions of this one and called one are private. But sounds not.
Cetin