>>>>>>Hi
>>>>>>
>>>>>>I have a grid whose data is a cursor - I search the grid by client and the search works OK
>>>>>>
>>>>>>How do I make the record I have found become the top record in the grid?
>>>>>
>>>>>See this
>>>>>
Re: Position of Child Form Record Thread #
1061639 Message #
1062503>>>>
>>>>I can see what you are trying to do but which grid procedure do i put the code in?
>>>
>>>I have a separate method for this called LocateRecordOnTop. Then you can call this method of the grid after search.
>>>
>>>See also the whole thread I quoted.
>>
>>I cant see how to make this work but thanks for your help
>>
>>Colin
>
>What do you mean you don't see? It does not have to be a grid's method, you can put this code right after LOCATE with full references of the grid.
This is the lostfocus event of textbox text2
This doesn't work
SELECT quotelist
LOCATE FOR UPPER(SUBSTR(quotelist.acclient,1,LEN(TRIM(this.value)))) = UPPER(TRIM(this.value))
thisform.refresh
local lnHeight
thisform.lockscreen=.T.
With thisform.grid1
lnHeight=.height
.height=10 && or small enough to only show one line
.height=lnHeight
Endwith
thisform.lockscreen=.F.
thisform.refresh
It brings up an error on the reference to grid1
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing