Hi!

Read VFP Grids, Part I article here at the Universal thread, to understand this issue better. Briefly: there is something that close the alias specified in the record source of the grid *before* you assign another record source to grid.

>Hi,
>
>I have a grid, which is controlled through 4 of different groups of option buttons. Not only is the grids recordsource controlled this way, but the grid headings are changed from bold to normal, and some of the column heading are also changed this way too. Also it’s possible to drill down through the grid by double clicking on a cell and then up pops a different form. All of this works fine, and you can click away to your heart content – so to speak.
>
>It’s also possible to search the grid for a particular record, by typing in the fund name into a text box. This too works well.
>
>The problem occurs once you try to return to using the normal options after using the text box to do the search. The recordsource still works, and returns the correct view, but it seems to loose the understanding of the grid heading names and also the ability to drill down to the other form.
>
>I tried to reinitialize the grid but this did not help, and comes up with the message ‘Unknown member …….’ despite the fact that it was a known member a minute before. The main source for the grid comes from views, and the search comes directly from the database.
>
>Once I have reinitialised the grid recordsource, I then place the view into it (the recordsource), this does work, dispite the error messages.
>
>Does anyone have any ideas as to what’s wrong, and more importantly how to get the grid to reacquire the grid properly?
>
>Cheers
>Rob