>I have a page frame with 2 pages. Page 1 contains some fields the user enters. Page 2 contains a grid. On page 1 the user sets some parameters and can then view the results on the grid on page 2. There are two sql statements. The first creates a table and sets the recordsource of the grid to that table. The user can then view it. The user can then come back to page one and set further parameters. A second SQL is executed which creates a cursor. The cursor is then set as the recordsource for the grid. When the SQL is executed the cursor has a subset of the records in the table. However, when the grid is viewed, it is populated with the entire base table,even thought the cursor is still selected. What am I doing wrong?

Try setting the grid's recordsource to nothing before your select, and resetting it afterwards:


THISFORM.Pageframe1.Page2.Grid1.REcordsource = ""
SELECT && whatever INTO CURSOR MyCursor
THISFORM.Pageframe1.Page2.Grid1.REcordsource = "MyCursor"