General information
Category:
Forms & Form designer
>>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
I am putting it into a cursor and I use it as the recordsource.
In the click event of the page, I refresh the page. I stated that
this is VFP 3.0, but it is VFP 5.0
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only