>>>>I would like to change the data environment after I
>>>>query on some records. How do I do this? After I change, I will want to change back?
>>>
>>>What exactly do you want to change?
>>
>>Good Morning Ed...
>>
>>I am working in a datafile on form. I will perform a query on this
>>datafile and I only want to display those records in the query. This means I will code a "select,from,where,into a cursor". When the user is finished with this cursor, the user will need to return to the datafile that he started with.
>>My questions is...
>>1. How do I change my data enviroment so I can display the query for the
>> user?
>>2. How do I change back to the datafile when the user is done with the
>> query?
>>
>>I need help with this one...thanks
>What I did in a similar situation was in the data environment set up a "dummy" cursor with an alias of "Dbedit" by using the "Create Cursor Dbedit (field1 c(1))" command in the init event for the data environment. Then I created a grid object with the control source referencing "dbedit". Issue your query to alias dbedit and it should work.
Hi Larry... I found the answer
1. do select...into cursor mycursor
2. thisform.fldname on the form.ControlSource="mycursor.field_name"
thats all...
to go back to your datafile
"select datafile"
rob