>I have created a form with a 2-page pageframe.
>The first page is used to search for a value in
>one of two tables. I would like for the search
>results to be displayed in a grid on the second
>page. I have tried various combinations for the
>recordsource of the grid. Either I get all records
>for the table, no records or the grid shows entirely
>white. The SQL I tried to use looks something like
>this:
> SELECT * FROM title,libkey where
> libkey.keyword = csearchword
>On the first page they can choose 2 different fields
>to search on. I need to be able to change the
>grid recordsource for each different search.
>
>Thanks in advance!
>Susan

Where do you put the results of the SQL? If you aren't using a cursor or table, do so and use that name as the data source for your grid