PMFJI, Nerissa

What about issuing a Form.Requery() after you've done the data manipulation in the SQL enviroment? That will take care of the form's primary BizObj as well as any children marked as requerying when the parent requeries.

You will also have to add code for any cdeLogicals used to display lookup views, but that's the general idea.

Hope that makes sense,
---J

>Hi Kevin,
>
>Since the cursors that I'm working on in my SQL statements are those that are really on my form where the records are displayed, it means that I have to create a data environment for my SQL manipulation and later load them to the cursors of my form to update the form display. It seems complicated to in MM. Is there a method that I can use to do that?
>
>Thanks a lot.
>
>Nerissa