>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
You might be better off using something like QBF Builder. You can get it at
www.classycomponents.com. This will allow your dataentry form to be a query form. It will optionally display a grid with the results.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer