>>>I have a form with a two grids. The grids are both children of a controlling table whose records are displayed in textboxes.
>>>
>>>The second grid sometimes has a filter set based on the displayed records of the first grid which also has a conditional filter.
>>>
>>>When I'm scanning through the master table, everything is fine. I can turn the various filters on and off and both grids display properly.
>>>
>>>But, when I edit the first grid (that's where all edits on the form are, all other controls are read-only), the second grid blanks out. The relationship is still there, but the grid won't display anything.
>>>
>>>Q: Can a grid be reinitialized? Or is there some other way I can prevent this from happening? Please help me.
>>>
>>>TIA
>>
>>Yes, you can reinitialize grid by:
>>cRecsource=Thisform.Grid1.recordsource
>>Thisform.Grid1.recordsource=""
>>Thisform.Grid1.recordsource=cRecsource
>>Sorry, I cannot give you more answers, because as you remember, I don't use temp relationships and prefer to use cursors (just because they are 'independent') as grid.recordsources.
>
>OK Ed, it's time for me to jump into the water and swim....
>
>This is a perfect example of where I should be using a SQL statment. I changed recordsourcetype to 4 and put the SQL statement in recordsource, but the grid won't show the result set. Refresh isn't doing anything. What am I doing wrong now?
>
>TIA
I have to admit again, that I don't have much experience with SQL statement as RecordSource. I use cursor alias and it works perfectly, because once cursor is created, I can modify it (regardless other data) to accomodate 'unusual' grid behaviour which alas is not rare.
Edward Pikman
Independent Consultant