>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?
Have you examined the cursor in Browse mode to see if it contains all the records, or the correct number? If it contains all records, then your SQL needs work, a NOFILTER may be needed, or the WHERE isn't right, maybe. If the cursor is correct, then the grid recordsource needs to be set differently than which ever way you're doing it...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.