>>How can I use this....
>>
>>Select * from Proyect ;
>>where Type_P = m.Type_P ;
>>and Number = m.Number ;
>>Into cursor ResultSet
>>
>>to present the information in textboxes in the form. Instead of a report or a grid.?
>
>Juan
>1) Add a 'Fields' property to your form
>2) Set the controlsource in your textboxes to be ThisForm.Fields.NameOfField, like in ThisForm.Fields.Type_P
>3) Run select * from proyect bla blabla
>4) SCATTER NAME ThisForm.Fields
>That's it. If you want to save back, use "gather name Thisform.Fields" command.
>
>HTH
>Jaime
>
>Let me see if I understand this...
>Like this...?
>
>Select * from Proyect ;
>where Type_P = m.Type_P ;
>and Number = m.Number ;
>Into cursor ResultSet <--- "ResultSet" is a temporary table?
>Scatter Name thisform.fields
>
>just like this?
>I have a lot of different text boxes... do i have to say...
>
>im still not sure how to express the code... :(
Exactly
Do this in a form with 1 or 2 textboxes and see how it behaves. don't forget you have to set controlsource for the textboxes to thisform.fields.blablabla
Jaime
Why do programs stop working correctly as soon as you leave the Fox?