>Yesterday's lesson was great. I have the SQL statement written and it is pulling the proper records from the table into a cursor.
>
>I have a form with a text box (for the user to enter the search text), a grid, and a cmdbutton that runs the show.
>
>The user enters the search text, presses the button and I use this:
>
>
>l_cSearchtext='%'+upper(alltrim(ThisForm.txtSearchString.value))+'%'
>
>select * from document where title like l_cSearchtext order by number into cursor temp1
>
>to pull the appropriate records into the cursor temp1.
>
>Now I want the cursor data to be placed in the grid. The grid has its ColumnCount set to -1, the RecordSource to temp1 and the RecordSourceType to 4 - SQL Statement.
>
>After the SQL statement, I refresh the form, but get nothing in the grid....what (OBVIOUS THING) am I missing here?
Set RecordSourceType to 1 (Alias) - type 4 would mean you provided the SQL statement itself as text in RecordSource, rather than the alias of the cursor to reference