Hi

If you can't be bothered even acknowledging the help I send you, because you've got a solution elsewhere, please don't bother to ask for my help in future. It took me a good 15-20 minutes this morning to write out a detailed explanation for you.

Terry McDonnell

>hi,
>
>-i try as under but still,
>-how i can see the result directly at page2,after i press at thisform.text1.value,
>-if my select statment not found where i can put amessage ("not found")
>and stay at page1 as setfocus.
>

>with thisform.pageframe1.page2.Grid1
>    .RecordsourceType = 4 && SQL
>    .Columncount = -1
>      .Recordsource = 'select * from mstr'+;
>      '   where UPPER(inname) = UPPER(TRIM(thisform.pageframe1.page1.text1.Value)) and nam1 = thisform.pageframe1.page1.text4.Value'+;
>      '   into cursor crsMyCursor'
>
>ENDWITH
>
>thisform.pageframe1.page2.Grid1.refresh
>

>
>thanks.
>m.qasem