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