>>>>I have perform a search using...
>>>>select *;
>>>>from datafile;
>>>>where lastname=search_name;
>>>>into cursor mycursor
>>>>
>>>>Now I want to user to pick the name he wants
>>>>in mycursor from a grid on a form.
>>>>How do I display the picked record in the datafile?
>>>
>>>First let the user pick the record then do the following :
>>>lcLastname = thisform.grid1.columnLastName.text1.value
>>>select *;
>>>from datafile;
>>>where lastname=?lcLastName;
>>>into cursor mycursor
>>
>>Hi Nabil
>>Thanks for your answer. I would like my search results displayed
>>on my form instead of in a browse type window. Can you help?
>>
>>Rob
>
>if you don't give it a destination (into cursor, table, etc.) it will put in a browse window...
i gave it a destination of..
INTO cursor anycursor
then..
SELECT anycursor
I would think that the cursor would use my form to display the
results. I would like to go back to the form I left before I
performed the SELECT statement using the results form the cursor.
any ideas?
rob