> 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
Use two different views or query results as RowSource.
Then you can fix the column order and the ORDER BY clauses to fit the ListBox.
If you want to run some code to run when ActivePage changes, put that code in the
Activate event of the new page, or in the
UIEnable event of a control on the activated page.
-Anders