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?
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!