>>I thought I had this thing licked but now I have another grid problem.
>>
>>I have a grid on a form. In the form Init method I have the following code:
>>
>>SELECT * FROM Deliverables WHERE nOSPKey=THISFORM.t_nOSPKey.VALUE INTO CURSOR Q_Deliv
>>
>>THIS.Grid1.RecordSourceType=1
>>THIS.Grid1.RecordSource="Q_Deliv"
>>THIS.Grid1.Column1.ControlSource="Q_Deliv.cAction"
>>THIS.Grid1.Column2.ControlSource="Q_Deliv.dDueDate"
>>THIS.Grid1.Column3.ControlSource="Q_Deliv.dcomplete"
>>
>>THIS.Grid1.Refresh
>>
>>This works fine and the grid displays the three columns properly. I have a refresh button and included the exact same code that I have in the Init method in the button click method. When I press the button the results of my cursor, Q_Deliv, are displayed in the grid instead of what I have defined for the columns. It's like the cursor was overlayed onto my grid. Any thoughts??
>>
>>TIA
>>
>>/Chris
>
>Chris, you have to preserve the formatting of the grid by setting THIS.Grid1.RecordSource=""
>as a first line before you rerun you SQL . Running the SQL again trashes the grid.RecordSource and the grid looses formatting.
>Another approach here may be to use the view based on the same SELECT and just REQUERY () it.
>
>Nick

Thanks Nick. I'd like to use the view based but the problem I have is how do I feed the uniqe key (THIS.nOSPKey.VALUE) into the view without setting a static value in the view first (I hope that was clear)?

BTW, THIS.Grid1.RecordSource="" worked.

/Chris