Hi Jerry,

Is this the Jerry that used to work on Port Royal Rd.?

Instead of changing the record source --which can cause all sorts of problems --why not simply use a parameratized view. If you don't have you're WHERE when the form loads, just set the view to open NODATAONLOAD and requery() it after setting your view parameter.


>Hi,
>I am using Grid on my form and would like to update information in the grid,
>based on user selection.
>After, SELECT statement return a record, VFP stops responding, CPU usage is 100%
>and only one solution is to kill VFP as a task.
>I tried it on Win98SE, Win2K - the same result.
>What I am doing wrong or there is an easy way to accomplish my simple task.
>Thanks
>
>THISFORM.grdSelect.RECORDSOURCE=""
>
>SELECT emplid,NAME FROM Employ WHERE emplid='ABC';
> INTO CURSOR GridLookup
>
>IF _TALLY<>0
> THISFORM.grdSelect.RECORDSOURCE="GridLookup"
>ENDIF