>>If I create a View on the fly in a form how do I add it to the forms DE?
>>
>>Thanks
>
Why would you do that.
>You can simple open and close the view in your form.
>But probably addobject() will help you. (Don't know if the cursor object can be added at runtime)
You can add a Cursor object to the DE at run-time but it won't do you any good unless you add it before the OpenTables method fires. You would have to have the add code in something like the BeforeOpenTables event.
Your suggestion is the way to go (IMO). There is no added benefit from adding it the DE.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao