>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

Use cursor as grid recordsource and rewrite the cursor any time you launch new search:
Select ..... Into Cursor tmpGriddata
Thisform.Grid1.recordsource=""
Thisform.Grid1.recordsource="tmpGriddata"
Thisform.Grid1.refresh