> Dear all;
>
> An incremental search button call a pageframe with 2 pages.
>
> Each page has a list.
>
> 1. The first page is ordered by id_no
>
> 2. The second page is ordered by name.
>
>
>
> PROBLEM
>
>
> 1. I have set the activepage on the pageframe to page 2, so that when a user clicks on the button
> focus should be set to the second page of the pageframe.
>
>
> However the list box in the second page which has to order by name is not ordered as expected.
>
>
> I have the following program in the calling button LOSTFOCUS PROCEDURE .
>
>

select vmaster
> index on name tag name
> set order to name
> go top
> 
> 
> THISFORM.PGF1.PAGE2.LIST1.VISIBLE=.T.
> 
> thisform.pgf1.activepage=2

>
>
> QUESTION
>
> What do I need to do in the list box in page2
>
>
> I am running vfp front end sql server backend.
>
> Thanks

Hi Solomon

After changing the Order you need to refresh the list:

THISFORM.PGF1.PAGE2.LIST1.refresh

Sometimes, you may need to REQUERY the source cursor.

THISFORM.PGF1.PAGE2.LIST1.requery

Why u r putting your code in the (LOSTFOCUS) not in the CLICK event of the button?

Ammar................IRAQ
---------------
I I I realy love foxite
___________________________